Topics

I have a strange question to ask that is causing me no end of frustrations.  I have to export my database and upload it to a different server.  I have done this many times before, but this time I am getting some very strange results.  Many of my tables are having their attributes changed during the export process.  For example, this is the structure of a field called 'id' the way it is on my freepgs database:


     id     int(11)         UNSIGNED     No         auto_increment

But when imported to the new server it winds up looking like this:


     id     int(11)     UNSIGNED     No     0     

The default zero and lack of the auto_increment statement are making the site unusable once it is moved to the new server because no one can add new content to the table.

Now, I could change this one field if I wanted to, but there are dozens of these errors all over the place in my database after it is imported to the new server.  I have tried different settings for the export including setting it to MYSQL40 and even MYSQL323 for compatibility but the errors still persist.  I know the new system has a lower version of mysql than Freepgs does.

Does anyone have any idea what I should try next because I am at the end of my rope on this.  I can't figure out why the exported file will not import correctly.

Thanks,
MaestroC

Did this cracker also affect anyones databases?  I reuploaded my site files from backups assuming that everything would work again but I am receiving multiple php errors now when trying to access the site. 

Does anyone know if the Joomla CMS uses any of the functions that the admins have disabled?

My site is at /cacris

Thanks,
MaestroC

When the old freepgs server burned up my site went with it  because I never bothered to backup the database.  I had copies of the site files, but they were no good without the database to go with them.  Now that my site is recreated and better than ever I want to make sure I never have this happen again, but backing up the DB via the phpmyadmin panel is tedious and I would prefer to be able to do an automatic backup at a regular interval.

Since I am hosted on the plesk server, is there a cron job that I could run to automatically backup my database and email it to me at my gmail account at a regular interval of say, every Sunday and Wednesday night?  If there is, what would be the command to put into the crobtab?  I tried doing it myself using suggestions from other web sites but it never seems to work.

The main issue for me is the database, but is there also a way to backup my entire directory, compress it, and email it as well?

Sincerely,
MaestroC
www.musicedmagic.com