|
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
|