Backing up/exporting in MYSQL

[GLENEE]

I use MySQL to store my data in one table (approx 7 million rows) and use MSAccess as a front end. I need to export the data out to a file to pass on to some else. I have tried using the Dump procedue without success, although MySQL message informs me that the database has successfully dumped. The *.sql file is created but the data is missing. I have tried exporting to a *.txt file but the message I recieve is "Query doesn't return fields". I think my ODBC connection is OK because i can view the records through Access, however if i try to export the data to a *.txt file from within Access I get an 'ODBC call failed" message.

 

[guelphdad]

Can you show us the mysqldump statement you are using? Are you using that directly in mysql?

 

[GLENEE]

This is the script file produced

# DBTools DBMYSQL - MySQL Database Dump
#

SET FOREIGN_KEY_CHECKS=0;

# Dumping Table Structure for usidatatable2

#
CREATE TABLE `usidatatable2` (
`invno` varchar(10) default NULL,
`usi` varchar(20) default NULL,
`payuin` varchar(100) default NULL,
`orduin` varchar(50) default NULL,
`siteid` varchar(10) default NULL,
`fsi1` varchar(255) default NULL,
`datefrom` datetime default NULL,
`dateto` datetime default NULL,
`svcecode` varchar(20) default NULL,
`svcecat` varchar(2) default NULL,
`ServiceID` bigint(20) default '0',
`description` varchar(100) default NULL,
`newcharge` decimal(20,4) default NULL,
`charge` decimal(20,4) default NULL,
`f2` varchar(50) default '0',
`PSTNCallMinutes` decimal(13,2) default '0.00',
`PSTNCharge` decimal(20,4) default '0.0000',
`PSTN` decimal(20,4) default '0.0000',
`BenefitEx` tinyint(4) default '0',
`ItemID` int(10) NOT NULL auto_increment,
PRIMARY KEY (`ItemID`),
KEY `datefrom` (`datefrom`),
KEY `invno` (`invno`),
KEY `ServiceID` (`ServiceID`),
KEY `siteid` (`siteid`),
KEY `svcecat` (`svcecat`),
KEY `svcecode` (`svcecode`),
KEY `usi` (`usi`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
#
# Dumping Data for usidatatable2
#
SET FOREIGN_KEY_CHECKS=1

 

[Kozusnik]

Did you maybe use the wrong format?

mysqldump -uusername -ppassword database table > dmp.txt

Mark