Migrating form ispcp imscp RC3

Quote from aseques

It seems to me that you are not starting from 1.0.7, hence all the inconsitencies with the database you are having.
About testing the migration, what I usually do is to replicate ALL the system to another server (we're using virtualization), and test that with a different ip, once the upgrade process has gone flawlessly, I then to the upgrade to the real server.

Hi, when I mean rollback I roll back with rsync to my last backup. Before any changes. At present I have a fully working 1.0.7 ISPCP system. If I launch the migrations scripts from the IMSCP RC3 I get the database error as posted above. I'm currently building a test VM system but the problem is with my stable production system. I can't advance What can I do as I really want to migrate ....

[/quote]

Hello ;

If you cannot deal alone with your migration, install teamviewer and send me the IDS. I'll be there this evening.
[/quote]

Meanwhile until the teamviewer meeting tonight a little info I've discovered:

When I try to mysqldump I get a strange error with the ISPCP database. Also if you see the imscp install log its a similar error:

root@sosaria:~# mysqldump --databases ispcp --opt -Qc --add-drop-database -p -r /root/mysqldump.sql
Enter password:
mysqldump: Got error: 1146: Table 'ispcp.php_ini' doesn't exist when using LOCK TABLES
root@sosaria:~# cat /var/log/imscp/imscp-setup.log
[Tue Aug 13 12:17:59 2013] [debug] iMSCP::Debug::verbose: Debug mode off
[Tue Aug 13 12:18:44 2013] [error] main::setupUpdateDatabase: [ERROR] Database update failed: Database update 52 failed.

Exception message was:
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ispcp.web_software_options' doesn't exist
Query was:

REPLACE INTO
`web_software_options` (`use_webdepot`, `webdepot_xml_url`, `webdepot_last_update`)
VALUES
('1', 'http://app-pkg.i-mscp.net/imscp_webdepot_list.xml', '0000-00-00 00:00:00')
;

root@sosaria:~#

Quote from aseques

If you rsynked databases without stopping mysql many times they might be broken. Best thing is that after migrating you do a mysqlcheck and if there are errors you restore from a mysqldump.

I get this error. What information is stored in the ISPCP database? Oviously the domains etc but a week has passed since my last mysqldump. Ive added no new users since the last dump, so what changes will I loose if i restore from the dump?

Also if I restore from the dump do I need to launch any commands after the restoration? Or will everything just work fine?

oot@sosaria:/home/rcraig# mysqlcheck -c ispcp -u root -p
Enter password:
ispcp.admin OK
ispcp.auto_num OK
ispcp.autoreplies_log OK
ispcp.config OK
ispcp.custom_menus OK
ispcp.domain OK
ispcp.domain_aliasses OK
ispcp.domain_dns OK
ispcp.domain_traffic OK
ispcp.email_tpls OK
ispcp.error_pages OK
ispcp.ftp_group OK
ispcp.ftp_users OK
ispcp.hosting_plans OK
ispcp.htaccess OK
ispcp.htaccess_groups OK
ispcp.htaccess_users OK
ispcp.lang_EnglishBritain OK
ispcp.lang_SpanishSpain OK
ispcp.log OK
ispcp.login OK
ispcp.mail_users OK
ispcp.orders OK
ispcp.orders_settings OK
ispcp.php_ini
Error : Table 'ispcp.php_ini' doesn't exist
status : Operation failed
ispcp.plugin
Error : Table 'ispcp.plugin' doesn't exist
status : Operation failed
ispcp.quota_dovecot
Error : Table 'ispcp.quota_dovecot' doesn't exist
status : Operation failed
ispcp.quotalimits OK
ispcp.quotatallies OK
ispcp.reseller_props OK
ispcp.server_ips OK
ispcp.server_traffic OK
ispcp.sql_database OK
ispcp.sql_user OK
ispcp.ssl_certs
Error : Table 'ispcp.ssl_certs' doesn't exist
status : Operation failed
ispcp.straff_settings OK
ispcp.subdomain OK
ispcp.subdomain_alias OK
ispcp.suexec_props OK
ispcp.tickets OK
ispcp.user_gui_props OK
ispcp.web_software
Error : Table 'ispcp.web_software' doesn't exist
status : Operation failed
ispcp.web_software_depot
Error : Table 'ispcp.web_software_depot' doesn't exist
status : Operation failed
ispcp.web_software_inst
Error : Table 'ispcp.web_software_inst' doesn't exist
status : Operation failed
ispcp.web_software_options
Error : Table 'ispcp.web_software_options' doesn't exist
status : Operation failed

Quote from aseques

Basically you would lose all the accounting data for this period, you can recreate only the missing tables from the dump, it's basically a text file, so you can remove all the proper working parts and load only the broken ones.

Hi, I've just checked my master SQL dump before I started to migrate and the mentioned tables above are not listed. I'm thinking they are not from ISPCP but maybe from the failed migration attempts IMSCP? Can you guys confirm?

I'm happy to make a donation for your time if you guys can help me finish this migration. At present I'm stuck with an ISPCP system I can't migrate

Please let me know. thanks
Rob

Quote from aseques

You should do a PM to nuxwin, he's the one that can help you the best, and has done remote support several times already

have done. Will wait for his reply.

Cheers,