| 12:00 pm on Jun 24, 2006 (gmt 0)|
This may sound dumb, and possibly is, but my first thought is:
BACK UP EVERYTHING, multiple times, and do that first.
The rest is details. -Larry
| 12:39 pm on Jun 24, 2006 (gmt 0)|
oh, no no no :) this is not what i meant :)
I know the steps, i did many restores by now, i just want to know if there is any easy way to be done. Any specific tools to be used. For example, all of you use the phpMyAdmin interface for restores?
| 1:02 pm on Jun 24, 2006 (gmt 0)|
If you have a backup in sql format you can just use the "sql" tab in phpmyadmin and paste your sql in there. It will then populate the database for you with the existing data.
Try this on another database first so you can test the data before using it on a live database.
| 9:10 am on Jun 25, 2006 (gmt 0)|
problem is that the sql is file very big and it doesn't work this way. is the backup of a phpbb with ~ 25,000 posts
| 9:14 am on Jun 25, 2006 (gmt 0)|
Ahh yea there is a limit on file size within phpmyadmin.
You might be able to use mysql administrator. It's a free download from the mysql website.
If that fails you might want to have a look into "mysql dump".
| 9:33 am on Jun 25, 2006 (gmt 0)|
[webmasterworld.com...] the big dump script works a treat.
| 5:56 am on Jun 28, 2006 (gmt 0)|
If you know how to SSH in with, for example, putty you can do (to back it up):
$mysqldump -uname -ppass --opt dbname > dbname.sql
then you can zip it, scp it to your home computer, whatever.
Then to restore:
$mysql dbname < dbname.sql
There is no limit on file size with this method (unless you're approaching the 2GB limit of some linux operating systems).