i have a .bat file that writes my record to a csv file. works fine in windows, but in linux it writes a file but theirs no data in it???

/usr/bin/mysqldump -h localhost -u root --tab--fields-terminated-by=';'
--lines-terminated-by="\n" --no-create-info ehpadmin Referral_Authorization > Referral.txt


am i misssing a bracket or something new to linux....???

thanks for the help

looks OK to me. Any error messages?

I dont get no error messages. below is my whole script it does everything but the writting to a file. it writes a file but theirs no data in it??? Something not confiqured right? i am the su- on my machine i have full writes to my table. DOnt get it??? Someone save me


#!/bin/bash
/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/script.sql
/usr/bin/mysqldump -h localhost -u root ehpadmin > backup.txt
/usr/bin/mysqldump -h localhost -u root --tab--fields-terminated-by=';'
--lines-terminated-by="\n" --no-create-info ehpadmin Referral_Authorization > Referral.txt
/usr/bin/mysql -h localhost -u root ehpadmin < /usr/etc/scripts/truncate.sql

Are you sure it isn't a password issue?

--
felix

i have basic set up root with no password
below is what my file outputs. very stange. why is it showing me all this garbage? i just want the data not server version or lock or nothing..... do i have to many privildges set???

-- MySQL dump 10.9
--
-- Host: localhost Database: ehpadmin
-- ------------------------------------------------------
-- Server version 4.1.11

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 */;

--
-- Dumping data for table `Referral_Authorization`
--


/*!40000 ALTER TABLE `Referral_Authorization` DISABLE KEYS */;
LOCK TABLES `Referral_Authorization` WRITE;
INSERT INTO `Referral_Authorization` VALUES ('MOMC8779394','AMAYA, JANNETH','F','19781203','11016 KITTRIDGE ST APT 1','N HOLLYWOOD','CA','91606','8187865951','MOMCG000','S ','S','','','','RETROACTIVE','20050605','YES','MAR K','AMICO','8187270142','8188855480','PHYSICIAN',' ','','GERBERG, ERWIN','PO BOX 190','SIMI VALLEY','CA','93062','8002876838','','RADIOLOGY',' ','','PREGNANCY CARE','','','','','','','','','','F','','','','F', 'THURSDAY, 9/29/2005','','PETE@WEST.COM','E01PRF059V000900','PETE' ,'953864875','A');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Referral_Authorization` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Before you said you didn't get any output.

This isn't garbage - it is useful info so the file can be used with the mysql command in a restore operation.

Look into the --compact and --no-create-info options of mysqldump

--
felix

I dont understand why im getting all this extra commands. if you look below you will see my windows output and my linux output. very different. DO i have the wrong privildges set???? write to file?? im new and thanks for all the help. just dont understand it. i have a execustable that works ...




in windows using the same script i get

MOMC0394651;MANOKIAN GHARGH, ARSINEH;F;19830811;26 RIBVERA PKY;BURBANK;CA;91501;8182609474;MOMCG000;RADICULAR CYST;5228;;;;RETROACTIVE;20050823;YES;KATHY;CAIRO; 8187270142;8188855480;PHYSICIAN;;;ADVANCE RAD OF;

in linux using same script i get
-- MySQL dump 10.9
--
-- Host: localhost Database: ehpadmin
-- ------------------------------------------------------
-- Server version 4.1.11

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!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 */;

--
-- Dumping data for table `Referral_Authorization`
--


/*!40000 ALTER TABLE `Referral_Authorization` DISABLE KEYS */;
LOCK TABLES `Referral_Authorization` WRITE;
INSERT INTO `Referral_Authorization` VALUES ('MOMC8779394','AMAYA, JANNETH','F','19781203','11016 KITTRIDGE ST APT 1','N HOLLYWOOD','CA','91606','8187865951','MOMCG000','S ','S','','','','RETROACTIVE','20050605','YES','MAR K','AMICO','8187270142','8188855480','PHYSICIAN',' ','','GERBERG, ERWIN','PO BOX 190','SIMI VALLEY','CA','93062','8002876838','','RADIOLOGY',' ','','PREGNANCY CARE','','','','','','','','','','F','','','','F', 'THURSDAY, 9/29/2005','','PETE@WEST.COM','E01PRF059V000900','PETE' ,'953864875','A');
UNLOCK TABLES;
/*!40000 ALTER TABLE `Referral_Authorization` ENABLE KEYS */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

Try this (on one line):

$ mysqldump -uroot --tab=. --fields-terminated-by=";" --lines-terminated-by="\n" --no-create-info ehpadmin Referral_Authorization

and look for the file Referral_Authorization.txt