Author |
Thread |
gibaphp |
Published: 2005/6/27 3:59 Updated: 2005/6/27 3:59 |
Just popping in
Joined: 2005/2/8
From:
Comments: 4
|
 Re: MySQL Database Restore
Please,
Exist module Xoops for this ?
|
|
|
jseymour |
Published: 2005/6/27 8:12 Updated: 2005/6/27 8:12 |
Webmaster
Joined: 2004/11/5
From: Ponte Vedra Beach, Florida
Comments: 201
|
 Re: MySQL Database Restore
Maybe, maybe not.  I use this script through the cron interface on cPanel, if I need to restore. Restore is usually a onetime operation, but, cron gives me access to the command line, since my host does not allow direct command line access. 
|
|
|
gibaphp |
Published: 2005/7/2 2:12 Updated: 2005/7/2 2:12 |
Just popping in
Joined: 2005/2/8
From:
Comments: 4
|
 Re: MySQL Database Restore
Ok, very Thanks 
|
|
|
nightshade |
Published: 2005/7/20 3:58 Updated: 2005/7/20 3:58 |
Supporter
Joined: 2005/6/23
From:
Comments: 21
|
 Re: MySQL Database Restore
Is Plesk any good? My hosting company offers it instead of cPanel. Or would you say that cPanel is much better and I should investigate trying to use it?
|
|
|
jseymour |
Published: 2005/7/20 9:52 Updated: 2005/7/20 9:52 |
Webmaster
Joined: 2004/11/5
From: Ponte Vedra Beach, Florida
Comments: 201
|
 Re: MySQL Database Restore
Plesk is good, but I prefer cPanel as it gives me more control over the options for my site. As long as you have access to MySQL and cron in plesk you can use this command line script to restore a database backup.
|
|
|
Guest |
Published: 2005/9/7 23:19 Updated: 2005/9/7 23:19 |
|
 Re: MySQL Database Restore
Do you know if the database name you are restoring to can be different from the original one you did the backup from?
I.e if you backup the database 'data1' using mysqldump in cron, can you restore that data to a database called data2?
|
|
|
jseymour |
Published: 2005/9/8 23:29 Updated: 2005/9/8 23:29 |
Webmaster
Joined: 2004/11/5
From: Ponte Vedra Beach, Florida
Comments: 201
|
 Re: MySQL Database Restore
To restore to a database with a different name you will have to edit the SQL file to reflect the name of the new database. Then it will restore with no trouble.
|
|
|
Guest |
Published: 2005/9/10 23:03 Updated: 2005/9/10 23:03 |
|
 Re: MySQL Database Restore
Works a treat too!
The mysqldump with cron is excellent for automated backups. Being able to restore to a different database means I can work on a copy of my xoops site without affecting the original. Perfect for testing out new modules without affecting the original working site and data.
Thanks for your help with this.
|
|
|
ravert |
Published: 2010/2/9 14:29 Updated: 2010/2/9 14:29 |
Just popping in
Joined: 2010/2/9
From:
Comments: 1
|
 Re: MySQL Database Restore
Very nice review! I searched for some tutorials at http://rapid4me.com , but found nothing informative, your article helped me much!
|
|
|
svetorim |
Published: 2010/9/16 0:21 Updated: 2010/9/16 0:21 |
Just popping in
Joined: 2010/9/16
From:
Comments: 1
|
 Re: MySQL Database Restore
|
|
|
valik |
Published: 2011/11/5 14:49 Updated: 2011/11/5 14:49 |
Just popping in
Joined: 2011/11/5
From:
Comments: 1
|
 Re: MySQL Database Restore
I use th is script throu gh the cron , but it does not wo rk.... ????
|
|
|