Backup/restore using phpMyAdmin/SSH

[LincolnForums]

Originally Posted by Rhoads

I tried but i get a error:

Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect -/bin/bash-2.05b$

Whats the problem, i use the command from your post, with my user and database name.

This is due to a hosting problem, chances are good your host doesnt have something configured correctly. I had the same problem while using dreamhost

Originally Posted by sinaluna

Should you close your board before backing up?

Thanks!

while its not neccassary, but you do run the chance of loosing any posts/changes that are made while backing up

[Snake]

Originally Posted by sinaluna

Should you close your board before backing up?

Thanks!

Well I'd say yes just in case you won't loose any forum data (such as threads, posts, members, etc) while performing a backup.

[RFViet]

Originally Posted by Logan70

You can also try and use:

http://www.ozerov.de/bigdump.php

It will allow for large dumps to be staggered, making it look like smaller pieces.

thanks !!

[imported_infitech]

Now i coul dnot backup using SSH FROM the old server because the old server did not support SSH, but i backed up using your phpmyadmin method and through admincp just in-case.

My new host offers SSH so i want to restore using SSH. Is this possible?

Also to i type in

run: mysql -u joeuser -p mydatabase < {this/is/my/database/path}/thisthenameofthebackup.sql

[Hornstar]

this command mysqldump --opt -u user -p dbname > /path....

Does it compress the database?

As my old database size was 929 megs (done through cpanel) and this one is 721 megs. (done through SSH)

[Bubble #5]

Originally Posted by Lil Ripsta

Select "gzipped" as compression.

Are you sure about that? vB suggests to not use any compression at all when saving the database...

[Gunshot]

Originally Posted by hornstar1337

this command mysqldump --opt -u user -p dbname > /path....

Does it compress the database?

As my old database size was 929 megs (done through cpanel) and this one is 721 megs. (done through SSH)

I notice that the database size is smaller when backing up with ssh...

but having backed up and restored numerous times now using ssh and the command you have posted, I have found it to be very smooth and works perfectly. I was using myphpadmin for back ups and bigdump.php for restoring.......but as the database grew I began getting errors and this method became unusable...

not to mention I can backup and restore a database in about 10 minutes using ssh, while the other method can take hours. It really sucks to spend 3 plus hours only to find you have a corrupted db

[TrueDeath]

Some hosts also offer automated MySQL backups at your defined times/when you select, you could always use https://vborg.vbsupport.ru/showthread.php?t=103259 if your worried about lost data.

[Bubble #5]

Originally Posted by TrueDeath

Some hosts also offer automated MySQL backups at your defined times/when you select

Site5 has a unique feature called 'Flashback' which automatically backs up every file that is one the server. You don't have to do anything. To restore a file simply click it from a master list and it's restored :bunny:

[Snake]

Whoa that's pretty hot. Is that a feature-already in cPanel 'cause I am always hoping for an automatic backup system for cPanel.