[SOLVED] Migrating databases larger than 8,192KiB?

colak · 2014-03-06 10:59:31

This is now solved and instructions can be found here

Time has come to move away from txd and I am migrating to Kaizen Garden

Could someone post an idiot friendly step by step guide on how we can import mysql databases larger than the max 8,192KiB stipulated in phpMyAdmin?

At the moment I have all the dbs in .sql format backed up in my computer.

Last edited by colak (2014-03-08 19:43:56)

juanjonavarro · 2014-03-06 11:39:37

Export the database in gzip format
Upload it to the new server, in directory tmp (create it if not exists)
ssh to your new server
Type: cd tmp
Type: gzip -d name_of_your_file.sql.gz
Type: mysql -h localhost -u username -p dbname < name_of_your_file.sql

Notes:

Replace “localhost” with mysql hostname if not localhost
Replace username with mysql username
Replace dbname with mysql database name
The command asks you for the password. This is the mysql password, not your ssh password
All this data is the same you put in your config.php file

lazyadmin · 2014-03-06 11:46:24

I like to use BigDump for tasks like these.

colak · 2014-03-06 12:13:07

Thanks so much guys. I’ll start with Juanjo’ suggestion and move on to bigdump if I’m stuck.

gaekwad · 2014-03-07 14:59:05

Yiannis – if you’re still using OS X, you could use SequelPro and avoid phpMyAdmin entirely. You might also get some info from this thread that might help.

colak · 2014-03-08 07:10:31

I have a problem at the moment as I don’t know the ssh connection addresses to KG

juanjonavarro · 2014-03-08 09:40:24

If your DNS is already pointing to KG, you can simply ssh your domain.

If not, you need to review your welcome message or ask your administrator.

colak · 2014-03-08 10:34:31

Hi, I changed all the name servers at my registrar’s yesterday and they point to KG but the sites are still in limbo returning blank pages. I guess I’ll wait a few more hours so as to allow for the change to happen before I start panicking.

gaekwad · 2014-03-08 11:20:54

Yiannis, I’m seeing www.neme.org now appearing on 23.105.43.31, but neme.org (no www) doesn’t resolve yet. www.neme.org is resolving with challenger.kaizengarden.us, so you’re nearly there. Perhaps check your DNS records to check the non-www address will resolve.

colak · 2014-03-08 17:17:23

Hey Pete

neme.org is now online but I still have problems with the forum subdomain at forum.neme.org.

What do you use to check the ips of sites? The whois I check my websites with do not return any ip addresses, just the name servers.

colak · 2014-03-08 19:04:40

Ok. Here’s what I did to migrate the large dbs from TXD to KG. I am posting it here should anybody need it.

Backing up in TXD.

step1. Connect via ftp and create a directory in the root of your account and call it backups
step2. In the command line (if you use a mac launch the Terminal app) type:

ssh accountname@server.textdrive.us

step3. you will be asked for the password
step4. when the server opens type

mysqldump -u accountname -p[mypassword] db_name > /users/home/accountname/backups/dbb.sql

step5. Compress your database as it will help with the download. In the command line type:

gzip -c /users/home/accountname/backups/dbb.sql >  /users/home/accountname/backups/dbb.sql.gz

step6. Go back to your ftp and download the compressed database from the backups folder

Migrating to KG

step1. Connect via ftp and create a folder called backup in the root of your account
step2. Upload your databases in .gz compression in the backup folder
step3. Connect to KG by typing

ssh username@server.kaizengarden.us

Type in your password when prompted.

step4. Un Zip your database online by typing

gunzip -c /users/home/accountname/backup/dbb.sql.gz > /users/home/accountname/backup/dbb.sql

step5. Type

mysql -u username -p[mypassword] db_name < /users/home/username/backup/dbb.sql

If all went well you would have all your database records in place.

In the directions above change:

server > server name
accountname> to your account name
[mypassword]> to your account password without the square brackets.
db_name> to your database name
dbb> to the name you want the backup to be

Last edited by colak (2014-03-08 20:09:28)

bici · 2014-03-08 19:29:44

colak wrote #279582:

[mypassword]> to your account password

db_name> to your database name

dbb> to the name you want the backup to be

thanks. Just to clarify if my password was secret would I enclose it in the [ ] i.e [secret] ?

Textpattern CMS

Textpattern CMS support forum

#1 2014-03-06 10:59:31