Uploading MySQL Table?
Moderator: General Moderators
-
csdavis0906
- Forum Newbie
- Posts: 17
- Joined: Thu Mar 27, 2008 9:36 am
Uploading MySQL Table?
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?
What kind of access do you have to the server?
If you have cli access...
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.
If you have cli access...
Code: Select all
mysql --user=username --password=password < MyDatabaseBackup.sqlOr you can make your own import system with php.