Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

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

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,777
Website GitHub Twitter

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

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)


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#2 2014-03-06 11:39:37

juanjonavarro
Plugin Author
From: Valencia, Spain
Registered: 2005-05-16
Posts: 485
Website

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

  1. Export the database in gzip format
  2. Upload it to the new server, in directory tmp (create it if not exists)
  3. ssh to your new server
  4. Type: cd tmp
  5. Type: gzip -d name_of_your_file.sql.gz
  6. 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

Offline

#3 2014-03-06 11:46:24

lazyadmin
Member
From: Germany
Registered: 2009-08-08
Posts: 25
Website

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

I like to use BigDump for tasks like these.

Offline

#4 2014-03-06 12:13:07

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,777
Website GitHub Twitter

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

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


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#5 2014-03-07 14:59:05

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,691
GitHub

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

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.

Offline

#6 2014-03-08 07:10:31

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,777
Website GitHub Twitter

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

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


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#7 2014-03-08 09:40:24

juanjonavarro
Plugin Author
From: Valencia, Spain
Registered: 2005-05-16
Posts: 485
Website

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

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.

Offline

#8 2014-03-08 10:34:31

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,777
Website GitHub Twitter

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

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.


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#9 2014-03-08 11:20:54

gaekwad
Server grease monkey
From: People's Republic of Cornwall
Registered: 2005-11-19
Posts: 3,691
GitHub

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

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.

Offline

#10 2014-03-08 17:17:23

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,777
Website GitHub Twitter

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

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.


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#11 2014-03-08 19:04:40

colak
Admin
From: Cyprus
Registered: 2004-11-20
Posts: 8,777
Website GitHub Twitter

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

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)


Yiannis
——————————
neme.org | hblack.net | State Machines | NeMe @ github
I do my best editing after I click on the submit button.

Offline

#12 2014-03-08 19:29:44

bici
Member
From: vancouver
Registered: 2004-02-24
Posts: 1,881
Website

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

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] ?


…. texted postive

Offline

Board footer

Powered by FluxBB