Upload MySql DB to server
Posted by: SPOKMIK (---.vl21-cph.dhcp.clearwire.dk)
Date: April 28, 2008 08:26PM

Hello.
As a new user of MySql I have a very basic question:

I have created the DB which works with PHP (a sort of member's registration, where new members register directly on my site). I have tried it out on localhost - it works fine.
BUT how do one upload the DB to the external server, for the site to work on the internet ?
I have searched e v e r y w h e r e without finding the solution to this issue.

Could anyone offer a step-by-step explanation ?

Thanks for any help.

«Mucho más temprano que tarde, se abrirán las grandes alamedas, por donde pasará el hombre libre para construir una sociedad mejor»

Options: ReplyQuote
Re: Upload MySql DB to server
Posted by: mystrymaster (---.dyn.optonline.net)
Date: April 28, 2008 09:18PM

Usually I would have the Sql manager program generate the db scripts then run them on your server.

Options: ReplyQuote
Re: Upload MySql DB to server
Posted by: yfastud (Moderator)
Date: April 28, 2008 09:22PM

you can use phpmyadmin to export then import it on your host, make sure to include drop table, or you can use mysqldump if more comfortable w/ mysql command

Have fun,

FREE One A Day
FREE Photo
FREE Games
FREE Websites
FREE Portable GPS
FREE WAMP Guides

Options: ReplyQuote


Sorry, only registered users may post in this forum.