D
dB9c1NznMl
Guest
Hello, we have been trying to duplicate a MYSQL database on a CentOS VPS, sadly with no luck. We can't export it, as it is too big. Does anybody know how we would go about duplicating it? Thanks in advance!
First off you would need a ssh client:@Brogan We are exporting it using phpmyadmin. How would one go about it using shell?
Hey, I tried that and no backup was made.I prefer to use this for dumping:
Code:mysqldump -u -p --single-transaction --skip-lock-tables database_name > /path/to/backup/database_name_$(date +%d.%m.%y).sql
[root@infernaldevelopers ~]# mysqldump -u root -p --single-transaction --skip-lock-tables xenforo > /var/www/html/backups/xenforobackup_$(date +%d.%m.%y).sql
Enter password:
I'm assuming that you did create the location that the /path statements point to, correct? If running on a VPS it should have worked (either one) if the paths existed.Hey, I tried that and no backup was made.
I did that and entered my password but there was no message and no backup.Code:[root@infernaldevelopers ~]# mysqldump -u root -p --single-transaction --skip-lock-tables xenforo > /var/www/html/backups/xenforobackup_$(date +%d.%m.%y).sql Enter password:
Yes I did create it.I'm assuming that you did create the location that the /path statements point to, correct? If running on a VPS it should have worked (either one) if the paths existed.
Be sure that after the -u that you place the DB username.Yes I did create it.
Be sure that after the -u that you place the DB username.
I just did a simple copy/paste of Brogans code and placed the username for my DB by the -u and changed the paths and it worked fine.
-u root
Same thing, no backup.-uroot
Is what it took on mine.
Same thing, no backup.
The name of my database is xenforodid you change the "xenforo" in pauls command to the name of your database?
It was only going to be there for a short period of time.Unrelated to the issue, but I would suggest storing the database backup in non public (not in /html/*) directory for security. Or at the very least protect the /backups folder from public access, if not done already.
mysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (x86_64) using readline 5.1mysql --version returns what?
Mysql does need some time to take the database dump, it is totally possible that it takes a few minutes or much more, before you get any feedback.I did that and entered my password but there was no message and no backup.
We use essential cookies to make this site work, and optional cookies to enhance your experience.