Import mySQL tables

[dragonxx4]

i need to import tables into a mySQL database. I have a file called sites.sql that contains the tables, but i have no clue how to import it.

[blue60007]

Do you have access to something like PHPmyAdmin (it would be in your admin/control panel)? There might be others your host might have installed, but that's the one that I'm familiar with.

I know how to do it if your host uses Cpanel as an admin panel...I'm not familiar with anything else though. Also, you could probably do it in a PHP page if you already have a MySQL database set up.

Also, do you have a MySQL database set up for the tables? Or do you need to do that too? You do have MySQL available with the host you are using?

[dragonxx4]

Originally Posted by blue60007 Do you have access to something like PHPmyAdmin (it would be in your admin/control panel)? There might be others your host might have installed, but that's the one that I'm familiar with. I know how to do it if your host uses Cpanel as an admin panel...I'm not familiar with anything else though. Also, you could probably do it in a PHP page if you already have a MySQL database set up. Also, do you have a MySQL database set up for the tables? Or do you need to do that too? You do have MySQL available with the host you are using?

I do have phpmyadmin, cpanel, and a database setup and ready for the tables. And yes i am using mySQL, thanks for the quick reply

[blue60007]

OK good...if you hop into phpmyadmin and select your database from the side menu....on the right you should see a tab named "Import". Go there and you should be able to hit the browse button and select the sites.sql file from your hard drive and it should upload (after hitting Go) and automatically create the tables...

[dragonxx4]

Worked great thabk you for the help

[mairving]

From the command line it is:

mysql -u username -p database_name < sqldump

This will prompt you for a password and import the file sqldump into your database overwriting anything that is in there.