Fantastico Update of Mambo

[edwurster]

I tried the fantastico update of Mambo, and it created a mess. I'm following the instructions to restore:

1- delete all the files listed in /home/xxxxxxxx/public_html/fantastico_fileslist.txt
2- delete /home/xxxxxxxx/public_html/fantastico_fileslist.txt
3- Untar /home/xxxxxxxx/fantastico_backups/.backup.1182556126.tgz
4- Empty the database xxxxxxxx_mamb1
5- Import the file /home/xxxxxxxx/fantastico_backups//backup.sql into the database xxxxxxxx_mamb1
6- Move /home/xxxxxxxx/fantastico_backups/ to /home/xxxxxxxx/public_html

I'm stuck on #4. How do I empty a database? Through php MyAdmin?

Then, how would I restore from my backup?

[midwest]

use phpmyadmin
select the database of choice

#4
drop all tables
note: do not delete the database, just drop the tables

#5
use the function under the import tab to "file to import"(that is the sql file you untared) If you run into time out problems ftp the sql file to your root and use ssh with the mysql monitor, or you may split the sql file into chunks by CREATE_TABLE sections.

standard disclaimer
YMMV
not responsible if your computer blows up, blah,blah.

HTH

[edwurster]

Originally Posted by midwest

use phpmyadmin
select the database of choice

#4
drop all tables
note: do not delete the database, just drop the tables

#5
use the function under the import tab to "file to import"(that is the sql file you untared) If you run into time out problems ftp the sql file to your root and use ssh with the mysql monitor, or you may split the sql file into chunks by CREATE_TABLE sections.

Are we sure about DROP instead of EMPTY?

[edwurster]

I went ahead and used EMPTY. If that doesn't work, I can go back and use DROP.

At the command line, how do I move the contents of:

/home/fantastico_backups/home/xxxxxxxx/public_html/

to:

/home/public_html/

I'll keep reading.

Edit 1:
mv fantastico_backups/home/xxxxxxxx/public_html/ public_html/
(this creates a new public_html within existing web public_html -- not a great idea.)

Edit 2:
mv fantastico_backups/home/xxxxxxxx/public_html/ public_html
(this also creates a new public_html within existing web public_html)

[edwurster]

Originally Posted by edwurster

At the command line, how do I move the contents of:

/home/fantastico_backups/home/xxxxxxxx/public_html/

to:

/home/public_html/

Seems that this is not possible from the ssh command line. Surprises me. This would be a very easy thing to do with Windows, whether gui or cmd.

[edwurster]

Easy way to move files:

Login to CPANEL and run FILE MANAGER.

There is a MOVE command there, but you have to be a little careful. Once you find a way to select the files and/or subdirectories you want to move, look at the very bottom of the list of files. There is an innocuous edit box, with just a home icon. This is the destination you want to move your files to, and you'll have to carefully edit the path.

I was able to reverse the mumbo jumbo that resulted from the "upgrade", and if anyone needs help with similar, I can probably add a few tips.

[midwest]

/home/fantastico_backups/home/xxxxxxxx/public_html/

to:

/home/public_html/


cp -r /home/fantastico_backups/home/xxxxxxxx/public_html/* /home/public_html/

-r = recursive directories
man cp

[midwest]

Originally Posted by edwurster

I went ahead and used EMPTY. If that doesn't work, I can go back and use DROP.

At the command line, how do I move the contents of:

/home/fantastico_backups/home/xxxxxxxx/public_html/

to:

/home/public_html/

I'll keep reading.

Edit 1:
mv fantastico_backups/home/xxxxxxxx/public_html/ public_html/
(this creates a new public_html within existing web public_html -- not a great idea.)

Edit 2:
mv fantastico_backups/home/xxxxxxxx/public_html/ public_html
(this also creates a new public_html within existing web public_html)

mv makes new
cp copies to existing

[midwest]

Originally Posted by edwurster

Are we sure about DROP instead of EMPTY?

look at the sql file, it should tell you all you need to know. but the sql file should make all the tables needed and populate them as the directions say to empty the database not empty the tables.

[Jim]

If the site hasn't changed we have backups. One from yesterday which is after the problem, and one from the day before

Jun 22, 2007

Probably some older ones lying around as well. The monthly was on one of the other servers in Sac that was shut off, but there's most likely a bunch spanning the last year somewhere around here.

The email warning being sent out is something new added to Fantastico.

[edwurster]

Originally Posted by Jim

If the site hasn't changed we have backups. One from yesterday which is after the problem, and one from the day before.

Thanks Jim. I was able to restore things using the fantastico backup.