ti57
asked on
MySQL dump does not dump data
When using the mysql dump, the resulting sql files do not contain any of the data. The database itself is at least 15MB, but the dump files are 4kb. Is there an easy way to dump the ENTIRE thing?
Larger question: are there any recommendations for MySQL backup to Amazon S3?
Larger question: are there any recommendations for MySQL backup to Amazon S3?
ASKER
Need an automated solution
ok, well phpmyadmin sqlcode goes like this:
--
-- Struktur-dump for tabellen `qsd_user`
--
CREATE TABLE `qsd_user` (
`UserID` int(11) NOT NULL auto_increment,
`UserName` text NOT NULL,
UNIQUE KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Data dump for tabellen `qsd_user`
--
INSERT INTO `qsd_user` (`UserID`, `UserUser`) VALUES (1, 'Smith');
INSERT INTO `qsd_user` (`UserID`, `UserUser`) VALUES (2, 'Walter');
INSERT INTO `qsd_user` (`UserID`, `UserUser`) VALUES (3, 'John');
----------------
so it seems like you need to select * from table_name and then parse INSERT lines in you dumpfile
--
-- Struktur-dump for tabellen `qsd_user`
--
CREATE TABLE `qsd_user` (
`UserID` int(11) NOT NULL auto_increment,
`UserName` text NOT NULL,
UNIQUE KEY `UserID` (`UserID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
--
-- Data dump for tabellen `qsd_user`
--
INSERT INTO `qsd_user` (`UserID`, `UserUser`) VALUES (1, 'Smith');
INSERT INTO `qsd_user` (`UserID`, `UserUser`) VALUES (2, 'Walter');
INSERT INTO `qsd_user` (`UserID`, `UserUser`) VALUES (3, 'John');
----------------
so it seems like you need to select * from table_name and then parse INSERT lines in you dumpfile
The UserUser in the INSERT lines is ofcourse UserName instead
ASKER
Looking for a scriptable mysql dump solution...not sure what to do with myphpadmin code above...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Try using phpmyadmin and dump structure and data