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
upload database from local to webserver
Moderator: General Moderators
-
junjustkim
- Forum Commoner
- Posts: 44
- Joined: Thu May 22, 2008 8:48 pm
Re: upload database from local to webserver
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
Then import filename.sql to your webserver, either using PHPMyAdmin or command line:
Otherwise you can go to the command line and do
Code: Select all
mysqldump --user=yourusername --password=yourpassword --opt --allow-keywords --extended-inserts > filename.sqlCode: Select all
mysql -u yourusername -p
[enter password]
use yourdatabasename
\. /path/to/filename.sqlSet Search Time - A google chrome extension. When you search only results from the past year (or set time period) are displayed. Helps tremendously when using new technologies to avoid outdated results.
-
junjustkim
- Forum Commoner
- Posts: 44
- Joined: Thu May 22, 2008 8:48 pm
Re: upload database from local to webserver
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

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