Quote:
|
Originally Posted by Jace
if you are doing that on your new host that makes sense, there is nothing there
ypou need to setup phpmyadmin on your old host and export from there
I am taking a nap right now, but I will be back in about 2 hours, if you still don't have it done I will give you a hand
|
i setup db on new host.. i went to phpmyadmin on old host & exported & saved file as an .sql i went to new host phpmyadmin & did what he said in the above post & got the results i posted...
the export options are ;
SQL
LaTeX
CSV for Ms Excel data
CSV data
XML
I chose sql as looks like the obviously correct one to me..
so, next to this are sql options with check boxes;
Structure ( i have checked)
Add 'drop table' ( i do not have checked)
Add AUTO_INCREMENT value (i have checked)
Enclose table and field names with backquotes (i have checked)
underneath is another option;
Add into comments Creation/Update/Check dates ( i do not have checked)
then after that is
Data ( i have checked)(& the next 3 not checked)
Complete inserts
Extended inserts
Use delayed inserts
& under that is a selction box ; Export Type & options are insert, update, & replace.. I had insert selected..
then saved as file w/ __DB__ template & no compression