I'm not going to use fantastico . so don't even suggest that.
i have problems transferring my database. On my localhost, my phpmyadmin is v 2.6.1 while here to 2.6.1-pl2.
I backup my database and now i cannot restore onto the webhost.
can anyone tell me what settings should i use for exporting a database?
Backup is easy. simply check compression method will lead you to backup your db. recommend zipped method.
None "zipped" "gzipped"
If you backuped at cpanel, open localhost.sql with editor.
and delete below line (maybe 3~4 line) and retry.
|CREATE DATABASE `test`;
do localhosts have cpanel? no.
i have to type
http://localhost/mysql/ to get into mysql then i have to go to the export and export.
are you getting an error while running the sql script ?
if yes, then can you possibly post the error message ?
there can be many reasons for the script execution failing, we'd better narrow down first.
can you try running only a few lines (5-10) from the script ?
and if this fails too, then you can probably post those few lines here.
meanwhile, I'll investigate the differences between the two versions of phpmyadmin that you mentioned.