Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#1 2007-02-13 12:54:34
- two7s_clash
- Member
- From: VA
- Registered: 2007-02-13
- Posts: 15
Migrating local OS X textpattern site to Dreamhost
Been working on a textpattern site locally and uploaded it to my
domain yest afternoon — copied over the files, setup a new mysql
database, imported the dump from my local database, then edited the
“config.php” file that textpattern uses. Unfortunately, everything
thing I try gives me a “Database unavailable.” I believe I’ve
configured everything correctly, since I can connect to another
textpattern installation usinfg almost the same configuration… on
the other hand, I’m able to connect to the database in question over the
command line using these settings.
Installation in question lives here:
http://www.f1shw1ck.com/clients/strategicglobalsolutions/htdocs/
config.php is:
<?php
$txpcfg[‘db’] = ‘ textpatternsgs’;
$txpcfg[‘user’] = ‘two7s_clash’;
$txpcfg[‘pass’] = ‘******’;
$txpcfg[‘host’] = ‘mysql.f1shw1ck.com’;
$txpcfg[‘table_prefix’] = ‘’;
$txpcfg[‘txpath’] =
‘/home/.lindy/f1shw1ck/f1shw1ck.com/clients/strategicglobalsolutions/htdocs/text pattern’;
$txpcfg[‘dbcharset’] = ‘utf8’;
?>
mysql database is: textpatternsgs
Installation that works lives here:
http://www.f1shw1ck.com/
config.php is:
http://www.f1shw1ck.com/
<?php
$txpcfg[‘db’] = ‘ textpatternsgs’;
$txpcfg[‘user’] = ‘two7s_clash’;
$txpcfg[‘pass’] = ‘******’;
$txpcfg[‘host’] = ‘mysql.f1shw1ck.com’;
$txpcfg[‘table_prefix’] = ‘’;
$txpcfg[‘txpath’] = ‘/home/.lindy/f1shw1ck/textpattern’;
$txpcfg[‘dbcharset’] = ‘utf8’;
?>
Looking at the databases I see:
Database Ascending Collation Tables Rows Data
Indexes Total Overhead
information_schema utf8_general_ci 16 0 0 Bytes 4.0 KB
4.0 KB 0 Bytes
textpattern latin1_swedish_ci 17 2,258 197.8 KB 137.0 KB
334.8 KB 916 Bytes
textpatternsgs latin1_swedish_ci 20 3,668 660.0 KB 190.0 KB
850.0 KB 0 Bytes
Total: 3 latin1_swedish_ci 53 5,926 857.8 KB 331.0 KB 1.2
MB 916 Bytes
mysql database is: textpattern
Any likely culprits? Did I import something incorrectly? A permission problem? .htaccess? I
followed the instrux here:
http://wion.com/journal/moving-a-live-textpattern-site-to-a-local-server
and here: http://textpattern.com/faq/149/occasional-database-unavailable-errors
pretty much to the letter.
Help a brother out, huh?
Existing is plagiarism.
Offline
Re: Migrating local OS X textpattern site to Dreamhost
did you change the “Site URL” in Admin > Preferences?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
#3 2007-02-13 14:48:36
- net-carver
- Archived Plugin Author
- Registered: 2006-03-08
- Posts: 1,648
Re: Migrating local OS X textpattern site to Dreamhost
two7s_clash
Does the dreamhost DB user you created have access rights to the ‘textpatternsgs’ DB — or do they only have rights on certain DBs?
Also, it looks like your charset on this DB is latin1_swedish_ci whereas you are telling TxP to use utf-8 when connecting to it.
— Steve
Offline
#4 2007-02-13 18:07:26
- two7s_clash
- Member
- From: VA
- Registered: 2007-02-13
- Posts: 15
Re: Migrating local OS X textpattern site to Dreamhost
Net:
>Does the dreamhost DB user you created have access rights to the ‘textpatternsgs’ DB — or do they only >have rights on certain DBs?
They have rights…
>Also, it looks like your charset on this DB is latin1_swedish_ci whereas you are telling TxP to use utf-8 when >connecting to it.
This works on the other installation… gave it a whirl but no dice…
colak:
Duh. I can’t conect to the admin panel, put I changed these fields in the database:
1 path_from_root / 2 publish text_input 0
1 path_to_site /home/.lindy/f1shw1ck/f1shw1ck.com/clients/strateg… 2 publish text_input 0
1 file_base_path /home/.lindy/f1shw1ck/f1shw1ck.com/clients/strateg… 1 admin text_input 0
1 tempdir /home/.lindy/f1shw1ck/f1shw1ck.com/clients/strateg… 1 admin text_input
This is whay my config file looks like now:
<?php
$txpcfg[‘db’] = ‘ textpatternsgs’;
$txpcfg[‘user’] = ‘****’;
$txpcfg[‘pass’] = ‘***’;
$txpcfg[‘host’] = ‘mysql.f1shw1ck.com’;
$txpcfg[‘table_prefix’] = ‘’;
$txpcfg[‘txpath’] = ‘/home/.lindy/f1shw1ck/f1shw1ck.com/clients/strategicglobalsolutions/htdocs/textpattern’;
$txpcfg[‘doc_root’] = ‘/home/.lindy/f1shw1ck/f1shw1ck.com/’;
$txpcfg[‘dbcharset’] = ‘utf8_swedish_ci’;
?>
Still no dice… help!
Existing is plagiarism.
Offline