Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Re: [SOLVED] Migrating databases larger than 8,192KiB?
Hi bici, No the password should not be enclosed in the square brackets. if the password was secret the command would read
mysqldump -u accountname -psecret db_name > /users/home/accountname/backups/dbb.sqlthe reason I enclosed it in the brackets was to emphasize the -p part which precedes it. I added this clarification to the original post.
Last edited by colak (2014-03-08 20:10:23)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
colak wrote #279578:
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.
My computer here is OS X using Google Public DNS. Doing a dig on neme.org gives me this:
$ dig neme.org
; <<>> DiG 9.8.3-P1 <<>> neme.org
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 33992
;; flags: qr rd ra; QUERY: 1, ANSWER: 0, AUTHORITY: 1, ADDITIONAL: 0
;; QUESTION SECTION:
;neme.org. IN A
;; AUTHORITY SECTION:
neme.org. 1799 IN SOA dns1.kaizengarden.net. dns-admin.kaizengarden.net. 2014030810 3600 300 3600 3600
;; Query time: 4965 msec
;; SERVER: 10.1.1.1#53(10.1.1.1)
;; WHEN: Sun Mar 9 09:25:25 2014
;; MSG SIZE rcvd: 93I still don’t get a ping response:
$ ping neme.org
ping: cannot resolve neme.org: Unknown hostHowever, using the www.neme.org hostname gives me different results:
$ dig www.neme.org
; <<>> DiG 9.8.3-P1 <<>> www.neme.org
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 10506
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0
;; QUESTION SECTION:
;www.neme.org. IN A
;; ANSWER SECTION:
www.neme.org. 21262 IN A 23.105.43.31
;; Query time: 26 msec
;; SERVER: 10.1.1.1#53(10.1.1.1)
;; WHEN: Sun Mar 9 09:28:14 2014
;; MSG SIZE rcvd: 46And the ping:
$ ping www.neme.org
PING www.neme.org (23.105.43.31): 56 data bytes
Request timeout for icmp_seq 0
Request timeout for icmp_seq 1
Request timeout for icmp_seq 2
Request timeout for icmp_seq 3
^C
--- www.neme.org ping statistics ---
5 packets transmitted, 0 packets received, 100.0% packet lossAt least it knows where the site is – I’m presuming ping is disabled as the site seems to load fine in a browser. Regarding forum.neme.org:
$ dig forum.neme.org
; <<>> DiG 9.8.3-P1 <<>> forum.neme.org
;; global options: +cmd
;; Got answer:
;; ->>HEADER<<- opcode: QUERY, status: NOERROR, id: 46799
;; flags: qr rd ra; QUERY: 1, ANSWER: 1, AUTHORITY: 0, ADDITIONAL: 0
;; QUESTION SECTION:
;forum.neme.org. IN A
;; ANSWER SECTION:
forum.neme.org. 21599 IN A 23.105.43.31
;; Query time: 2519 msec
;; SERVER: 10.1.1.1#53(10.1.1.1)
;; WHEN: Sun Mar 9 09:30:09 2014
;; MSG SIZE rcvd: 48Which is fine. Again, ping falls silent but does at least resolve:
$ ping forum.neme.org
PING forum.neme.org (23.105.43.31): 56 data bytes
Request timeout for icmp_seq 0
Request timeout for icmp_seq 1
Request timeout for icmp_seq 2
Request timeout for icmp_seq 3
^C
--- forum.neme.org ping statistics ---
5 packets transmitted, 0 packets received, 100.0% packet lossIt looks like the non-www prefix of neme.org isn’t playing nice, at least on my computer. I just tried to view your site (www and non-www) over lynx from a Media Temple server and neither seem to work, though that might be down to tardy DNS updates.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
Hi Pete it seems that the whole of KG is down
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
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?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
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)
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
slogin is an alias for the ssh client => use ssh.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
Thanks guys. I’ll keep ssh
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
Another question:) When I am on step 4
mysqldump -u accountname -pmypassword db_name > /users/home/accountname/backups/dbb.sqlI 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?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
You could use an option file containing the password, using --defaults-extra-file=file_name
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
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 = mypasswordYiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
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.
Offline
Re: [SOLVED] Migrating databases larger than 8,192KiB?
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline