how do I import a Jumpline mySQL backup?
Jumpline totally screwed up a whole slew of things when they changed servers...
I have a file called keithlubrant_com.sql which was I file I created through phpMyAdmin. It is the dump of the structure and data...
How can I go about importing that while I wait for Jumpline to get here act together? My db is not the most recent, but at least it is something...
Thanks,
Keith
"I'm a singer, not a programmer!"
[url]www.keithlubrant.com[/url]
Peter J. Boettcher posted this at 13:50 — 15th March 2002.
They have: 812 posts
Joined: Feb 2000
I'm not sure how to restore the db through PHPAdmin, but through the shell the syntax is:
mysql database < backup-file.sql
For more info check out this link: http://www.mysql.com/doc/m/y/mysqldump.html
PJ | Are we there yet?
pjboettcher.com
mairving posted this at 17:06 — 15th March 2002.
They have: 2,256 posts
Joined: Feb 2001
Make sure of a couple of things when you import the data.
One is to make sure that the < is going the right way.
If it is going > this way, it will take your empty database and overwrite it with nothing, so backup.sql will have no data at all.
Also you will probably need to do this at the command line:
/pathto/mysql DATABASE_NAME -u USERNAME -pPASSWORD < /pathto/backup.sql, specifying pathnames, etc.
Mark Irving
I have a mind like a steel trap; it is rusty and illegal in 47 states
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.