FROM WINDOWS TO LINUX DATABASE TRANSFER ISSUE

hi everybody,

i just transferred my dolphin 6.1.6 based website developed on wamp, to a linux based hosting.

now the problem is that the wamp environment is not case sensitive but the linux environment is case sensitive.

therefore it gives me errors that the tale , for example "Profiles" does not exist or table "Modules" does not exist and so on, although they do exist and are all in lower case, thats why linux based environment is unable to read them.

The solution to this problem is changing a mysql variable lower_case_table_names status to 1, but my hosting is a shared hosting and they can not do so, bcz they say that it will effect other sites on that shared hosting.

All i want to know is that is there anyway that i can export my database in such way that there is no problem with the linux environment

OR

Is there any other solution, bcz there is a lot of data in my database, and i dont want to use a fresh database.

thanks in advance

Quote · 23 Sep 2010

hi,

plz any help will be great

thanks

Quote · 23 Sep 2010

You have to edit the database table name one by one via php my admin. or edit the SQL to import before running it.

Quote · 23 Sep 2010
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.