Messages

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

Please disregard.  I figured out the problem.  Turns out it a file had not been properly restored.

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

I'm glad to know I am not the only one having issues. 

In my case though none of the email forwards work either.  Mail sent to my email forwarders never make it anywhere.  They don't get through to their forwarded destination nor do they get bounced back to the sender.  I started an inquiry about it using the help form, and on Monday night they said they restarted the plesk server services, but still no mail is getting through.

Thanks for the suggestion, but I know there has got to be a way to do it automatically.  Even if it is just a simple php script that I can have cron call to execute on a regular basis.

I do use phpmyadmin, but only when I remember to do it.  That is why I lost my entire site when the fire hit I hadn't made a backup in several weeks.  To combat my absentmindedness I want it to be automatic and simple.

How big is your backup file?  If it is a huge file and is compressed, it could be taking longer than 300 seconds for the server to decompress the archive and then create the files in the database.  When this happened to me once I had to upload the archived database backup into a folder in my account and then ask the system operators to do the restore for me.

-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