Database Backups are failing most of the time

[Hubcap]

I've been trying to become famaliar with the backup and restore features of osC Merchant and PHP MYADMIN

and find that most of my efforts to restore a backup end up with errors with only the first two tables

showing. I tried updating to the 2.2.RC2a and it crashed the database, tried a restore from the previous

day and it failed with only the first two Tables showning. (online site)

I can get it back up with a backup a few months old but its frustrating to redo the changes again and again.

 

any ideas

[MrPhil]

How did it "crash the database"? Was there an error reported during an SQL IMPORT operation? If so, there should have been a specific error reported in the SQL file. It's also possible that nothing was wrong with the SQL file, but you went over some host-imposed process time limit during the import. If that happens, you might be able to ask your host about doing it for you (they can bypass time limits), or you can slice up your backup (.sql) file into smaller pieces and run them separately. So, specifically what kind of errors are you seeing?

[Hubcap]

Sorry cannot remember specific error but since the last good backup in May

I get the first two tables restored then

ERROR SQL query

Create Table administrators

xxx

xxx

 

My SQL said:

#1214 The used Table type does not support full text indexes

 

Installed update to RC2a it then said it could not read data base

I think I'll try the install.php just for the effect....

[MrPhil]

For "full text index", I think you need to have a table type of "MyISAM". Perhaps you somehow ended up with some other table type, such as "InnoDB"? Is that in the .sql (backup) file, or your system default? Look at the backup versus the oscommerce.sql installation backup, and see if you need to add a MyISAM table type to your backup.

 

I think I'll try the install.php just for the effect....

If you're trying to restore the database on an otherwise working system, you would have "DROP TABLE" and "CREATE TABLE" statements in the .sql file to clean out the old tables and create fresh copies, and then fill them up with "INSERT" statements. Just be sure that you have the appropriate table types either explicitly or by changing the system default.

[Hubcap]

Thanks, I did find the administrators table set at InnoDB

Changed it to MyISAM

 

 

Now for testing