Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2005-11-14 12:54:51
- LuciferVandros
- Member
- Registered: 2005-09-09
- Posts: 20
Moving to host - MySQL Problems Ahead?
Hello.
I have been developing my website locally using MAMP, which I believe is running MySQL 4.1.x I am going live soon, but my host is running MySQL 4.0.13. Is there any reason that I should expect major problems here when I do a SQL dump and try to import it? Going back to an earlier version has me concerned.
-L
Offline
Re: Moving to host - MySQL Problems Ahead?
I don’t think there should be any problems. Just make sure you chose the correct export options to be compatible with the older version.
Ed
Offline
Re: Moving to host - MySQL Problems Ahead?
Here is some info:
http://dev.mysql.com/doc/refman/4.1/en/downgrading-to-4-0.html
Yes, it could be tricky, given that Textpattern uses utf8 where available (mysql4.1 -yes, mysql4.0 no). So you’ll have revert to latin1, and adapt the config.php as well.
Offline
#4 2005-11-14 20:50:07
- LuciferVandros
- Member
- Registered: 2005-09-09
- Posts: 20
Re: Moving to host - MySQL Problems Ahead?
Thanks guys. I just found out my new host recently upgraded to 4.1.13….there’s one less headache I think.
Offline
Re: Moving to host - MySQL Problems Ahead?
O.k. This is the thread for me as well.
I am trying to port my textpattern istallation from my old mac to my new mac, but I can’t get the old database to load into the new mac.
Setup:
Old mac: MAMP 1.0b, PHP 4.3.11, MySql 3.23.49
New mac: MAMP 1.0, PHP 4.4.0, MySql 4.1.12
I made two back up mysql databases.
1. db_backup plugin. It only allowed me to make a gz.zip file.
2. PhpMyAdmin. Export to a .sql file.
When trying to bring the back ups to the new machine through PhpMyAdmin, the gz.zip. gave an Error: File could not be read.
When I tried to load the .sql file I recieved the following error: MySQL said:
- - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘ID` int(11) NOT NULL auto_increment, `Posted` datetime NOT NULL default ’0000-’ at line 2 .
Should I convert it upon export like mentioned above. Also, what will happen when I decide to move it to texdrive? Will I have to again convert it?
Last edited by mattmikulla (2005-11-14 22:59:33)
Art Rogue – Fine Art Photography
Offline
Pages: 1