• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

MySQL 4 to MySQL 5 migration dropped auto_increment

H

HoneyMonster

Guest
I have just migrated a bunch of domains from a Plesk 7.5 MySQL4 PHP4 server to a Plesk8.1 MySQL5 PHP5 server. To my suprise the Plesk migration manager completed without any errors. Yay was I happy!

Then I noticed that every website was broken as the auto_increment attribute had been removed from the primary key of every table!

Is this likely to be an issue with upgrading MySQL4>5 or a bug in the Plesk migration manager? I assume that the migration manager simply takes a dump of the database and then imports it into the new one.
 
I think this is a big problem with pleskbackup, because I've restored from other machines with no problem.

It just happened to me after a backup and restore. I am ****ing steaming pissed right now.

WHAT GOOD IS A BACKUP THAT DOESN'T PROPERLY BACKUP?!
 
You must log in or register to reply here.

Similar threads

R
Resolved MYSQL server loses connection while trying to drop psa database to import dump.
Replies
1
Views
3K
RMoto
R
ScottGoddard
Resolved Issues with Plesk accessing MySQL admin account
Replies
8
Views
7K
timelabs
timelabs
ScottGoddard
Resolved Migration Tool - Access denied for user 'admin'@'localhost'
Replies
6
Views
4K
ScottGoddard
ScottGoddard
Hex
Forwarded to devs MySQL Governer with Plesk
Replies
4
Views
2K
Hex
Hex
A
Issue Migration issues broken pipe
Replies
1
Views
3K
Bitpalast
Bitpalast
Back
Top