I am trying to create an automated backup of my database. I found that the most recommended way to do this was use mysqldump. I have version 4.1x of mysql installed on my local computer. I tried to use the following command to create a backup:
mysqldump -u<UserName> -p<PassWord> -h<WH4L Server IP Host> DBName > test.txt
And it creates the following text file:
-- MySQL dump 10.9---- Host: <MWH4L IP> Database: MYDB-- -------------------------------------------------------- Server version 4.0.24-nt-max/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
but no tables or data.
Anybody have any clues what I am doing wrong or have any suggestions?
Thanks,
-J
When you say automated, are you talking about a backup process that would run say, once a week or something? I could be wrong, but I don't believe WebHost4Life has scheduled job capability (also called a cron job).
Regarding your database backup, you can easily do that using phpMyAdmin, which is available through the WebHost4Life control panel. It is far easier than using mysqldump. :)
I have used and make some backups using the myadmin screen via the WH4L panel and it works on demand. I however want something that is automated.. Say run every night at midnight (just to throw an example out) to backup all the live data in case of something bad happening. I know that WH4L does not support anything like this currently, but there must be some way I can back up a mysql database to a remote drive (my server on my network for instance)?