Up;oading SQL files in PHPmyadmin

[bfehler]

Hi there ,

 

this, I should think is a very simple question, but, how do i Import SQL scripts,

 

many modules/addons say generally at the end of installation to load a .sql file in PHPmyadmin.....

 

how do i do this ?

 

regards

[rusty1001]

Hi there ,

 

this, I should think is a very simple question, but, how do i Import SQL scripts,

 

many modules/addons say generally at the end of installation to load a .sql file in PHPmyadmin.....

 

how do i do this ?

 

regards

 

 

hi

 

In phpmyadmin click on the database that you want to imort into

assuming it is an sql file, check the sql (has no other options )option import and then import,, as far as I understand if you are importing into the whole database it should hane the same name as your database that you are importing into.

The sql code (open in text file /open with IE explorer or similar to check) should have 'drop table if exists' and and 'create table of' the same name other wise you will get duplicates, if adding an existing database (if new dont worry) if you are importing to just a table click on that table and browse, do the same back up first!!

hope this helps

russell