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

colak · 2015-04-09 11:58:53

I am revisiting this post of mine as I am rewriting it for txptips and I am wondering if slogin will be safer than ssh on step 2. Can someone advise?

gaekwad · 2015-04-09 12:27:46

Isn’t slogin ~~a symlink~~ an alias to ssh anyway? That’s my understanding, anyway.

Edit: what Ruud said below

Last edited by gaekwad (2015-04-09 12:40:01)

ruud · 2015-04-09 12:37:35

slogin is an alias for the ssh client => use ssh.

colak · 2015-04-09 13:57:26

Thanks guys. I’ll keep ssh

colak · 2015-04-09 15:39:30

Another question:) When I am on step 4

mysqldump -u accountname -pmypassword db_name > /users/home/accountname/backups/dbb.sql

I get a response from the server that my connection is not secure. Is there any way I can make that connection secure in light of the fact that I am using a password in there?

ruud · 2015-04-09 22:06:56

You could use an option file containing the password, using --defaults-extra-file=file_name

colak · 2015-04-11 06:40:55

Hi ruud. Thanks so much for your advice.

I now have

mysqldump -u user --defaults-extra-file=/path/to/myfile.cnf db_name | gzip -c > /path/to/my/backup/folder/db.sql.gz

which creates the dump but I also get an error

mysqldump: unknown variable 'defaults-extra-file=/path/to/myfile.cnf'

in myfile.cnf I have:

[mysqldump]
user = myusername
password = mypassword

ruud · 2015-04-11 18:07:18

Leave out the -u user part.
Btw, if you’re documenting this, make sure to add that the myfile.cnf file should have permissions set to 600.

colak · 2015-04-12 05:22:36

ruud wrote #289913:

Leave out the -u user part.

I’m blind as a bat. Thanks so much yet again.

Textpattern CMS

Textpattern CMS support forum

#16 2015-04-09 11:58:53

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

#17 2015-04-09 12:27:46

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

#18 2015-04-09 12:37:35

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

#19 2015-04-09 13:57:26

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

#20 2015-04-09 15:39:30

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

#21 2015-04-09 22:06:56

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

#22 2015-04-11 06:40:55

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

#23 2015-04-11 18:07:18

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

#24 2015-04-12 05:22:36

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

ruud wrote #289913:

Board footer