Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#13 2008-06-10 21:58:58
- masa
- Member
- From: North Wales, UK
- Registered: 2005-11-25
- Posts: 1,095
Re: My god, what have I done?
I’m no expert in these matters, but the few times I migrated a db, I first created a new one from scratch and selected utf8_general_ci as the character set. Then I imported the sql file. This has worked fine for me.
Offline
Re: My god, what have I done?
by no means i want to make the situation even more complicated but may i recommend mysqldumper ? it’s an excellent piece of software that makes backing up and restoring really, really easy.
Offline
#15 2008-06-10 23:00:39
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: My god, what have I done?
More than one hour of silence after masas post… that finally did the trick, right?
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#16 2008-06-10 23:02:26
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
haha, no, i’m actually fooling around with that mysql dumper right now. i’m in way over my head. it’s a neat tool, though.
Offline
#17 2008-06-10 23:15:58
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
goodness… something worked! or, at least, i was able to upload my sql without any errors. Now what? :D
Offline
#18 2008-06-10 23:29:56
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,315
Re: My god, what have I done?
Sorry, completely clueless now! =D
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
Re: My god, what have I done?
brokenumbrella wrote:
i was able to upload my sql without any errors. Now what? :D
could it be that you’ve uploaded it but didn’t choose to restore the db from that file? also, i guess it would be a lot easier if someone would help you directly, look around in mysqldumper/phpmyadmin and fix it for you. remotely describing this kind of procedure can be tough. (that person wouldn’t be me though, i’m busy :P — uli? haha)
Offline
#20 2008-06-10 23:35:09
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
Hahaha, it is pretty weird. my brain is packed with too much new stuff. head explody
right now i’m trying to figure out if i should reinstall txp or try some sort of update thing.
Offline
Re: My god, what have I done?
brokenumbrella
At some point you will need to go update or create a new config.php file. It is located in your textpattern install under /textpattern/config.php
Until then Txp won’t see your database.
edit
sorry – I didn’t see your most recent post. Must have crossed.
You said that this site was built for you some time ago?
- If your original install was heavily modified
- If your site hasn’t been updated for since it was created,
- If you need your site back up asap
Then you may want to keep the same version of txp for now, and update later.
However, if it were me, I’d probably install a fresh version of the latest Txp release and bring everything up-to-date.
(to be more accurate – I’d install the latest svn version, but that’s beside the point).
With a fresh install, you can then drop in your updated config.php file and you should be able to connect to your database. Remember to remove the /textpattern/setup folder
Mike
Last edited by maverick (2008-06-10 23:50:48)
Offline
#22 2008-06-10 23:43:14
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
Thanks, maverick. I just did that (actually just edited the old config by specifying a table prefix). it still wants me to do a setup, though. but the tables are already set up, aren’t they? since i imported the sql?
Offline
Re: My god, what have I done?
re: the configuration file
You will want to make sure the the user name and password and mysql host for the new host is updated also. These are more important. The table prefix is the optional if I remember correctly.
re: the tables
Did you use the “restore database” option?
If so, you should be able to see the tables, and if you browse them you should be able to see the data.
Mike
edit
If you don’t have the config file set up properly, it will want you to do a full set up. If it is correct, it seems like it goes to the set up page, but gives a warning that it appears that the configuration file already exists (I think – its been a while since I tried that. Normally I drop in my config.php and delete the setup file at the same time).
Last edited by maverick (2008-06-10 23:57:53)
Offline
#24 2008-06-10 23:58:50
- brokenumbrella
- Member
- Registered: 2008-06-09
- Posts: 36
Re: My god, what have I done?
I’m afraid to touch them tables; i already deleted them all then restored them with the sql from my old host. the current message reads “Textpattern database table already exist. Can’t run setup.”
Offline