Simple MySQL Importing table command question

Hey everyone

I have made a backup of one of my Oscommerce table called "customers" (customersbackup.sql) sql format instead of csv.

I tried restoring it via phpMyAdmin but it wont let me, it was trying to read it as a txt or csv, I dont see any option of .sql in the import function. Is there a command that I can use to restore this backup in the shell?

Please advise

Thanks
Gav

 

What do you mean it does not let you? What error message do you get?

In phpmyadmin you goto the database and import. Then in the first box "File to import" browse for your file. Find your customersbackup.sql file.

In the third box "Format of imported file" make sure you have SQL enabled.

Click go button.

That should be all.

 

Hi

I wish I can import the whole database because it will be as easy as that but I am only importing a single table of the database and it doesn't have that option in phpMyAdmin.

Is there a SSH command to import a single table to a database?

Thanks
Gav

 

If you want to try and run the script from the shell interface, simply upload the sql file and then log into mysql on the server.

then type source <filename and path>;

Hope this helps