How to duplicate MYSQL database on CentOS VPS?

[bwfcwalshy]

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.


#1 you enter this:
[root@infernaldevelopers ~]# mysqldump -u root -p --single-transaction --skip-lock-tables xenforo > /var/www/html/backups/xenforobackup_$(date +%d.%m.%y).sql

#2 mysql asks you for your password
Enter password:

#3 nothing happens, you do not get a single character back from the system. This step might take a few minutes or half an hour.

#4 after everything is done, mysql gives you a feedback message.


And I totally agree with @TMC , if everyone can access your database on infernaldevelopers.com/backups/xenforobackup_currentdate.sql you are in huge trouble.

Yeah I have the backup and it is in a secure place.

 

[TPerry]

One thing you may want to contemplate... it looks like you may be running an older version of mySQL. I am pretty sure that 5.1.73 is a tad bit outdated. I'm on 5.6 myself.

 

[MattW]

I am pretty sure that 5.1.73 is a tad bit outdated

Most likely the one which installs by default with cPanel.

 

[Sheratan]

Most likely the one which installs by default with cPanel.

Then it must be an old cPanel because 11.38 is using 5.5 (it can't upgrade if you still use mysql 5.1)

 

[MattW]

Then it must be an old cPanel because 11.38 is using 5.5 (it can't upgrade if you still use mysql 5.1)

I actually meant CentOS, my fingers were in autopilot