Migration issue
Permalink 1 user found helpful
Hi all. I developed my first Concrete5 site on Windows, not knowing the camel case issue on the database install.
I'm want to move to a host with a Linux server and I can't find an easy, or not easy, way to rename all database table names to camel case.
It seems every answer I've found is either old (plugin) or doesn't work (renaming errors.)
Has there been any progress made on this issue, or should I just find a windows hosting solution?
Thanks!
I'm want to move to a host with a Linux server and I can't find an easy, or not easy, way to rename all database table names to camel case.
It seems every answer I've found is either old (plugin) or doesn't work (renaming errors.)
Has there been any progress made on this issue, or should I just find a windows hosting solution?
Thanks!
I received - An error occurred while downloading the package.
It doesn't look like your add-on works with the newest version of Concrete5.
Thank you anyway!
It doesn't look like your add-on works with the newest version of Concrete5.
Thank you anyway!
I just unpackaged it directly to packages and it installed, but when I went to use the migration tool I received - Class 'Concrete\Package\DatabaseMigration\Src\DbFix' not found
I don't know what's going on there, did you install the latest version from the download dialog box?
I just checked the file and it is there, correctly namespaced, with the Class in it...
I just checked the file and it is there, correctly namespaced, with the Class in it...
So I was running an old version and it ran correctly when I ran the newest version. However, I get this error when running the script on my database - # MySQL returned an empty result set (i.e. zero rows).
So I added lower_case_table_names = 0 to my.ini so I could run it from the dashboard. This resulted in this error - Maximum execution time of 30 seconds exceeded.
Thank you for your help with this. Please let me know if there is anything you can think of that can fix this.
So I added lower_case_table_names = 0 to my.ini so I could run it from the dashboard. This resulted in this error - Maximum execution time of 30 seconds exceeded.
Thank you for your help with this. Please let me know if there is anything you can think of that can fix this.
Yes sure, your PHP max_execution time is 30 seconds, which is too short to alter each and every table name through a PHP script.
If you can, set your php execution time to something much longer for this task and get it back to something quicker after this one is done.
If you can, set your php execution time to something much longer for this task and get it back to something quicker after this one is done.
This is weird. I successfully ran the script on my database. I received this message - Import has been successfully finished, 966 queries executed. But it didn't change the names of the tables.
Have you reloaded the db afterwards? Are you sure you checked the same db that is used for that site?
I wouldn't know how this can successfully run without any changes to the table names....
I wouldn't know how this can successfully run without any changes to the table names....
Yes and yes. I restarted MySQL on my computer.
Have you tried lower_case_table_names = 2
Below [mysqld]
Below [mysqld]
Yes. I ran the migration from within Concrete5, and I received a message that migration was successful. So I restarted MySQL and the table names are still in lowercase.
I can PM you the database if you want to try on your end.
I reran the migration tool again and it looks like it worked.
This is very important - "lower_case_table_names = 2"
Thanks for your help!
This is very important - "lower_case_table_names = 2"
Thanks for your help!
Community Member Ramon has built this super useful package just for that purpose:
https://www.concrete5.org/marketplace/addons/database-migration...