Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2005-10-05 22:51:48
- nightcity
- New Member
- Registered: 2005-10-05
- Posts: 4
textpattern database
I am switching hosts and I am wondering how do I go about transferring my tp db to my new host? Help is appreciated.
Offline
Re: textpattern database
There is a product called sqlyog available at http://www.webyog.com/sqlyog/index.php that will allow you to copy a database to another host. The free edition won’t allow a database move from what I remember, however they have a trial version of the full featured product that will do what you want.
I tried it out on my site which was around 1100 articles at the time and it worked great. Just had to go in and change the config.php on the new host to reflect the new values and it was fine.
Ren
Offline
#3 2005-10-06 02:01:26
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: textpattern database
Use mysqldump, or the Export option in phpmyadmin, or Rob’s database plugin.
Alex
Offline
#4 2005-10-06 02:56:28
- nightcity
- New Member
- Registered: 2005-10-05
- Posts: 4
Re: textpattern database
zem, I have used the mysqldumb, now i have a .sql file, how do I import it on my new host using mysql?
Offline
#5 2005-10-06 05:04:44
- zem
- Developer Emeritus
- From: Melbourne, Australia
- Registered: 2004-04-08
- Posts: 2,579
Re: textpattern database
Either at the command line (mysql < backup.sql), or with phpmyadmin.
Alex
Offline
#6 2005-10-06 18:36:07
- nightcity
- New Member
- Registered: 2005-10-05
- Posts: 4
Re: textpattern database
Ok…new problem:
ERROR 1064 at line 21: You have an error in your SQL syntax near ‘ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1’ at line 41
Any thoughts how to go about this? Should I create a new db with the latin char set?
Offline
Re: textpattern database
The target database is a different version of mysql than the source-mysql version.
You can use the switch “—compatible=name” for mysqldump, see the manual for details:
http://dev.mysql.com/doc/mysql/en/mysqldump.html
Offline
#8 2005-10-06 21:19:59
- nightcity
- New Member
- Registered: 2005-10-05
- Posts: 4
Re: textpattern database
That took care of that error. Now this:
ERROR 1136 at line 574: Column count doesn’t match value count at row 73
Any ideas?
Offline
Pages: 1