|
|
|
|
Joined: Dec 2004
Posts: 36
Junior Member
|
|
Junior Member
Joined: Dec 2004
Posts: 36 |
Hello,
can someone please tell me the correct command line to fill in in Admin > Database Tools > SQL Command - to perform a full db dump.
I'm having problems with this and kind find the answer after a whole day searching around.
Thank you very much in advance.
nosleep
|
|
|
|
|
Joined: Mar 2001
Posts: 644
Member
|
|
Member
Joined: Mar 2001
Posts: 644 |
Control panel > Database Tools > Backup Tables Tab > All tables option
|
|
|
|
|
Joined: Dec 2004
Posts: 36
Junior Member
|
|
Junior Member
Joined: Dec 2004
Posts: 36 |
no, that will perform a table by table backup. My db is 4 Gig. I want to perform a complete dump, best gzip.
that is the command I need.
nosleep
|
|
|
|
|
Joined: Mar 2001
Posts: 644
Member
|
|
Member
Joined: Mar 2001
Posts: 644 |
Eww. I use phpmyadmin for that. Sorry.
|
|
|
|
|
Joined: Oct 2001
Posts: 213
Member
|
|
Member
Joined: Oct 2001
Posts: 213 |
mysqldump --opt --u <forumdbusername> --password <forumdbuserpassword> <forumdbname> > /path-to-backup-directory/forumdb.sql
|
|
|
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: 808
Joined: July 2001
|
|
|
Forums63
Topics37,575
Posts293,931
Members13,823
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
