Re: Database lock on mysql import - Information

When you say locked, do queries on the other databases fail with an error? If so, whats the error? Is it all queries, or just inserts? Also, how are you doing your export and import? Sent from my iPad On Sep 10, 2012, at 2:38 AM, Roland RoLaNd wrote: > > Dear all, > > I realize this is a very

Database lock on mysql import - Information

Dear all, I realize this is a very newbie question so bear with me please. I know that when you import/export a DB its tables are locked to ensure consistency and no data corruption. but why would other DBs on the same server get locked if im importing/exporting one DB ? in other words: expo

Re: mysql import or write my own Perl parser

Both load data infile and mysqlimport both support the ignore option. If you are loading a file into a table with a unique index and duplicate rows in the file any duplicates will be silently ignored. On 4/19/05, newbie c <[EMAIL PROTECTED]> wrote: > thanks for the reply! I am not too concerned a

Re: mysql import or write my own Perl parser

thanks for the reply! I am not too concerned about cutting out the columns as I may need to other information for later. I was just wondering does it make a difference if both of the columns that I am interested have entries that are NOT unique? Also, at what point does one need a parser or use

Re: mysql import or write my own Perl parser

awk is probably the best tool I can think of for cutting columns out of a text file. Something like awk -F \\t '{ print $2 "," $3 }' my_file could be used to pick the second and third column out of a file prior to importing it. -Eric On 4/18/05, newbie c <[EMAIL PROTECTED]> wrote: > Hi, > > I am

mysql import or write my own Perl parser

Hi, I am about to create a database and there are a number of files that I need to load into the database. They are tab delimited files. One of the files contains about 4 or 5 columns. I am only interested in the second and the third column right now but I will load the whole table. The val

Re: mysql import problem

It sounds like the file is actually a MySQL database. Possibly an innodb file? You will need to create the requisite table definition so MySQL knows how to read it, then you might be able to read it. j- k- On Thursday 04 March 2004 12:08 am, Egor Egorov wrote: > Manda Sairam <[EMAIL PR

Re: mysql import problem

Manda Sairam <[EMAIL PROTECTED]> wrote: > > Hello Sir, > I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I > tried opening the file using load data file command but failed with errors .Actually > the problem is i donot know about the columns or the details abou

mysql import problem

Hello Sir, I have a file with the name doc.db.001 It is a binary file and it is a mysql file.I tried opening the file using load data file command but failed with errors .Actually the problem is i donot know about the columns or the details about the db file.How can i import such a file. regard

mysql import log

Hi All, Can anybody tell me how can I get a log of my database import command. Sohail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MYSQL import wizard

Hi, I am having a problem with the imporot wizard in MySQL, as I don't know wha'ts wrong Im doine, I tried to import from a text file, csv, .mdb, all dont get me any data in the destination table, can some one advise ? (may be if some one is willing to talk me through MSN messagner/yahoo messan

[SOLVED] Re: MySQL Import Script Works on Master Not on Slaves

Sorry to have bothered the list, for anyone's info... You have to have the CDF files on `all' servers, not just the MASTER in order for the mysqlimport to work. Robert B. On Tue, 29 Oct 2002, zxcv wrote: > > Hello all, > > I have a cron job that: > > 1 - truncates some working tables [WORKS

MySQL Import Script Works on Master Not on Slaves

Hello all, I have a cron job that: 1 - truncates some working tables [WORKS | BOTH] 2 - does a mysqlimport on some CDF files [WORKS | MASTER_ONLY] 3 - truncates a selection of production tables [WORKS | BOTH] 4 - select from working into production tables [WORKS | BOTH] Step 4 doesn't work on

mysql import problem

Hello List! I am having an extremely unusual problem with MySQL3.22.27 running on a Sun UltraII Solaris 7 (latest patches applied). This implementation of MySQL 3.22.27 has been rock solid for better than 2 years now. We have a primary/failover system here, and the primary 'sync

MySQL Import

I used the export script for MSAcess and got my text file, ya , there are three tables in it. I have used LOAD DATA to import small single table info but how do I import ones with more tables properly. Do I create the tables first or how do I past into the monitor program. Using Windows version.