Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
Problem moving database
Hi All,
We’ve recently had to move servers and I’ve followed Textbook’s instructions for moving host. I copied the old TXP folder via ftp and amend the config file. I then did a mysql dump and uploaded it to the new database. So far, so good. However, when I log-in to the new site I get this warning which I can’t begin to decipher, I would really appreciate some advice -
Warning: Table 'DatabaseName.txp_prefs' doesn't exist select val from txp_prefs where name = 'version' in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Warning: Table 'DatabaseName.txp_prefs' doesn't exist select name, val from txp_prefs where prefs_id=1 in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Warning: Table 'DatabaseName.txp_prefs' doesn't exist select name from txp_prefs where name = 'path_to_site' in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Warning: Table 'DatabaseName.txp_prefs' doesn't exist insert into txp_prefs set prefs_id=1,name='path_to_site',val='/var/www/02/17/37/domain/www' in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Notice: Undefined variable: language in /var/www/02/17/37/domain/www/textpattern/index.php on line 64
Warning: Table 'DatabaseName.txp_lang' doesn't exist select name, data from txp_lang where lang='' in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/02/17/37/domain/www/textpattern/lib/txplib_misc.php on line 177
Warning: Table 'DatabaseName.txp_lang' doesn't exist select name, data from txp_lang where lang='en-gb' in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/02/17/37/domain/www/textpattern/lib/txplib_misc.php on line 177
Warning: Table 'DatabaseName.txp_users' doesn't exist select nonce from txp_users where name='name' AND last_access > DATE_SUB(NOW(), INTERVAL 30 DAY) in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82
Warning: Cannot modify header information - headers already sent by (output started at /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php:82) in /var/www/02/17/37/domain/www/textpattern/include/txp_auth.php on line 169
Warning: Cannot modify header information - headers already sent by (output started at /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php:82) in /var/www/02/17/37/domain/www/textpattern/include/txp_auth.php on line 170
Warning: Table 'DatabaseName.txp_users' doesn't exist select privs from txp_users where name = '' in /var/www/02/17/37/domain/www/textpattern/lib/txplib_db.php on line 82Offline
Re: Problem moving database
Did you check your new database to see if the tables txp_prefs, txp_lang, and txp_users were created when you dumped into it, and if they were, do they contain viable data?
Last edited by joebaich (2009-07-17 23:15:50)
Offline
Re: Problem moving database
Hi Joe,
Thank you for your reply. Yes, I’ve checked all the tables, everything seems fine and they have data. I wonder if it would be easier to do a fresh install and then import the old data – or would this cause the same problem?
Offline
#4 2009-07-20 16:46:23
- RalphFFM
- Member
- Registered: 2008-10-05
- Posts: 40
Re: Problem moving database
“Warning: Table ‘DatabaseName.txp_prefs’ doesn’t exist…”
Is this really the correct name(s) of the table(s)?
Do you dumped and imported all the tables?
Offline
Re: Problem moving database
Hi RalphFFM,
Yes, the table names appear to be prefixed by the database name – not sure if they should be. The other approach I can try is importing the old database using rss admin db manager, I just need to work out the mysql and mysqldump paths.
Offline
Re: Problem moving database
Certainly try using rss_admin_db on a fresh TXP installation (same version as you had on the original site) to import the dump. On a fresh installation, that plug-in will likely populate the mysql and mysqldump paths fields for you but normally they are simply mysql and mysqldump anyway. I took your Databasename table prefix in the error message to be the correct name for the database on your new host, one would expect them to be added like that. The table names themselves are txp_prefs, txp_lang etc right? Normally, one wouldn’t invoke the option to add one’s own prefix to the textpattern table names unless there was a good reason to do it.
Offline
Pages: 1