NotebookForums.com › Forums › General Notebook Discussions › Linux & Other OS's › Backing up website.....HELP!!
New Posts  All Forums:Forum Nav:

Backing up website.....HELP!!

post #1 of 5
11/26/06 at 6:00pm
Thread Starter 
Hi

Well I'm currently running Ubuntu 6.06. I had setup my laptop as server for a forum. I had used phpbb and mysql. I recently bought a new hard drive. I want to know what the easiest way of getting my website back up and running on my new hdd which is using ubuntu 6.06.

I tried copying my old www directory over to the new one but got the errors:


Warning: mysql_connect(): Access denied for user 'root'@'localhost' (using password: YES) in /var/www/forum/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /var/www/forum/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /var/www/forum/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database


Is the mysql stuff saved in directories other then the the www directory? Did I incorrectly chmod something? Do i have to reinstall all the programs like phpmyadmin, and phpbb?

Any help would be GREATLY appreciated.

Thanks
Reply
Reply
post #2 of 5
11/26/06 at 6:29pm
PHPBB has a built in tool to dump the db.

Just dump it and re-create another DB on the new hard drive. Input the dump files and blammo.
Reply
Reply
post #3 of 5
11/26/06 at 7:29pm
Automatix has some gui based backup scripts that I use. Works extremely well. If you want to do remote backups you can always use this command:
Code:
ssh serveraddress.com "tar -czf - /home/userdirectory" >backup_name.tgz
It won't get your mysql stuff, but you can specify anything you want and it will compress and transfer on the fly. I would recommend using mysqlcc or phpmyadmin to do a backup of your database.

If you install the backup utliity from automatix on the server and do a restore on the new machine after you take care of all the updates you should be good to go. The utility does have a restore feature.
Reply
Reply
post #4 of 5
11/26/06 at 9:36pm
Thread Starter 
YES!!!
I got my site back up!
Thanks a lot GZS and bigtrouble77!!!
I ended up reinstalling phpbb and mysql and just reloading the tables with the backup feature of phpbb. (i had a back up of all my themes and images)
Reply
Reply
post #5 of 5
11/27/06 at 9:11am
Yea copying your www directory is one thing, but you need to copy the SQL tables, which as you noticed are not part of it. Anyways, have fun.

Seablade
Reply
Reply
New Posts  All Forums:Forum Nav:
  Return Home
  Back to Forum: Linux & Other OS's
NotebookForums.com › Forums › General Notebook Discussions › Linux & Other OS's › Backing up website.....HELP!!