Log in

View Full Version : Backup!


Rapdis
05-09-2002, 01:00 PM
OK... in the control panel, i normally use the backup bit!

SQL Dump of data

and check all of them.... if my entire content is deleted on tha server.... can i restore from this sql file?

if not.... how can i back up the complete forum? :confused:

Oh and i noticed u have added... number of users browsing this forum... how can i add that?

Sparkz
05-09-2002, 01:06 PM
Yes, you can restore from that backup.

Rapdis
05-10-2002, 11:13 AM
Thanks!

nycunderground
10-13-2002, 06:41 AM
how do you restore from the sql file?

refertech
10-13-2002, 12:59 PM
Well i never use that feature in the CP if thats what you want to call it. I find it is much more reliable to us telnet or ssh assuming you have shell access with your host. I also have myphpadmin but it tends to timeout if you go much over 2 megs on your database size, buts its great for view tables in the database. Here are the backup and restore strings i use in ssh (which is almost like telent)

Backup:
mysqldump --opt -u username -p database name >/dir/onyour/server/backup/10_12_02.sql

Restore:
mysql -u user name -p database name < /dir/onyour/server/backup/10_12_02.sql

After you enter this you will be prompted for your password which you wont think is being typed in but it is so just keep typing it.

Mark

NTLDR
10-13-2002, 04:58 PM
There is also a Restore hack thats integrated into the ACP by Birdie501, this don't work will all hosts though.

DrkFusion
10-13-2002, 05:03 PM
There are constant timeouts though if the database is big.

-Arunan