Uploading MySQL Table?

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
csdavis0906
Forum Newbie
Posts: 17
Joined: Thu Mar 27, 2008 9:36 am

Uploading MySQL Table?

Post 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...
User avatar
Zoxive
Forum Regular
Posts: 974
Joined: Fri Apr 01, 2005 4:37 pm
Location: Bay City, Michigan

Re: Uploading MySQL Table?

Post 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.
Post Reply