FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


unable to transfer db.





n0obie4life
I'm not going to use fantastico Smile. 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?
sean
Backup is easy. simply check compression method will lead you to backup your db. recommend zipped method.
Code:
Compression
        None    "zipped"   "gzipped"


If you backuped at cpanel, open localhost.sql with editor.
and delete below line (maybe 3~4 line) and retry.
Code:
CREATE DATABASE `test`;
USE test;
n0obie4life
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.
n0obie4life
anyone?
mOrpheuS
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.
Wink
n0obie4life
never mind solved it
Related topics
script backup database
problem in sql and importing db.
Unable to log in to cpanel or via ftp
Anyone?
Strange Mysql-database
Installing, Partitioning & Formatting HDDs
an annoying problem - PLEASE help
Co myslicie o mojej stronce??
Thumbs.db and _vti_cnf
PHP DB Error: syntax error
Advanced MySQL db merging Tutorials
Transfer limit
[PHP] phpbb registration - add to other db
Unable to delete
Reply to topic    Frihost Forum Index -> Support and Web Hosting -> Web Hosting Support

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.