|
|
|
|
Joined: Apr 2002
Posts: 206
Member
|
|
Member
Joined: Apr 2002
Posts: 206 |
To save some confusion, as I know someone will try it.. [] type: mysqldump -u *dbuser* -p *databasename* > dumpfilename.dmp then enter your dbpassword at the prompt when that's done, type gzip dumpfilename.dmp then you can ftp that file (in binary mode) to your new host... telnet/ssh there and: type gunzip dumpfilename.dmp.gz mysql -u *dbuser* -p *databasename* < dumpfilename.dmp enter your dbpassword at the prompt.
I reformatted the above -- anything enclosed in *'s should be replaced with username/database/whatever, but don't include the *'s.
I figured since the command does contain a triangle brace, it'd be an idea not to display examples containing triangle braces that are only there to indicate where to insert info.
Hope I'm not confusing anyone.
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 21,080
Joined: March 2000
|
|
|
Forums63
Topics37,583
Posts293,957
Members13,826
| |
Most Online151,614 Nov 14th, 2025
|
|
Currently Online 34299
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 1
|
|
|
|
|
|