Page 1 of 1

Uploading MySQL Table?

Posted: Mon Apr 21, 2008 3:56 pm
by csdavis0906
I have just completed my first app in php & MySQL and it's all running fine on my local machine. My website's host only gives me the option of creating a new database - which I did. My question is how do I then go and upload my tables which already contain data. I've googled for solutions but have found nothing specific. Any assistance would be greatly appreciated! Thanking you in advance...

Re: Uploading MySQL Table?

Posted: Tue Apr 22, 2008 12:20 am
by Zoxive
What kind of access do you have to the server?

If you have cli access...

Code: Select all

mysql --user=username --password=password < MyDatabaseBackup.sql
Otherwise if you have phpmyadmin, which most hosted solutions have, you can use that to import.

Or you can make your own import system with php.