Page 1 of 1

upload database from local to webserver

Posted: Sun Jul 06, 2008 10:36 pm
by junjustkim
hi to all

Could anyone help me on how to upload my database from localhost into webserver. I created sample website and database from my localhost and now I want to upload into webserver. All the files I already uploaded but not yet my database I don't know the step how to move on. This is my first time.

Thanks in advance

Thank you

Re: upload database from local to webserver

Posted: Sun Jul 06, 2008 10:40 pm
by s.dot
Are you using PHPMyadmin? If so you can go to 'export' and get a dump of your database and then import it on your server.

Otherwise you can go to the command line and do

Code: Select all

mysqldump --user=yourusername --password=yourpassword --opt --allow-keywords --extended-inserts > filename.sql
Then import filename.sql to your webserver, either using PHPMyAdmin or command line:

Code: Select all

mysql -u yourusername -p
[enter password]
use yourdatabasename
\. /path/to/filename.sql

Re: upload database from local to webserver

Posted: Sun Jul 06, 2008 10:44 pm
by junjustkim
Thanks for your immediate replied.

Yes, I am using PHPmyadmin. I will make it a try and informed you later

a million thanks to you

Cheers
:P