Re: Importing data, indexes, and analyzing tables.

2004-06-17 Thread David Griffiths
rse, you don't always have a mysql dump file. After importing a mysql dump file, it's wise to analyze all tables imported. I found that SHOW INDEX FROM table; would show the cardinality (the number of unique values) of an index. The more unique the data being indexed, the faster the inde

Importing data, indexes, and analyzing tables.

2004-06-16 Thread David Griffiths
We have a somewhat large database, with a snapshot of the data that we import into the database. Normally, we create a database, create the tables, import the data with "LOAD DATA", add the indexes, and then the foreign keys (we are using InnoDB, 4.0.18). We call this the load-data-method. Som

Re: importing data

2004-06-04 Thread Ben Clewett
This is just my experience. But if you are doing this sort of work, it may well pay to construct your own import program. There are many ways of doing this, like parsing an email message, or using a XML/SOAP server. This will probably pay on the long run, as you can introduce filters, data che

importing data

2004-06-04 Thread Paul Kruger
Hello.. Im a new sql user so if this is a common prob Please be kind Im trying to set up mysql 4.0.13 With a database that contains 60k records… The client wants to import 6 records a week With near 4mill records in a database… My problem is I don’t want to give ssh access to The machine…

Re: Exporting/Importing Databases

2004-06-03 Thread Robert A. Rosenberg
At 21:54 -0700 on 06/02/2004, David Blomstrom wrote about Re: Exporting/Importing Databases: --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: >Third, my practice database in

Re: Exporting/Importing Databases

2004-06-03 Thread David Blomstrom
Wow, I tried importing my SQL file again, with the referential integrity statements. This time I got a NEW error: Database geoblue_world - Table continents running on localhost Error There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also

Re: Exporting/Importing Databases

2004-06-03 Thread David Blomstrom
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > David Blomstrom <[EMAIL PROTECTED]> wrote: > >> If you use command-line client you can do: > >> > >> mysql> SET FOREIGN_KEY_CHECKS = 0; > >> mysql> SOURCE file_name; > >> mysql> SET FOREIGN_KEY_CHECKS = 1; > > > > Does anyone on this list know... > >

Re: Exporting/Importing Databases

2004-06-03 Thread Egor Egorov
David Blomstrom <[EMAIL PROTECTED]> wrote: > --- Egor Egorov <[EMAIL PROTECTED]> wrote: >> David Blomstrom <[EMAIL PROTECTED]> wrote: >> > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> >> wrote: >> >> You just got caught with the old Referential >> >> Integrity Gotcha. It >> >> will not allow you

Re: Exporting/Importing Databases

2004-06-03 Thread David Blomstrom
--- Egor Egorov <[EMAIL PROTECTED]> wrote: > David Blomstrom <[EMAIL PROTECTED]> wrote: > > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> > wrote: > >> You just got caught with the old Referential > >> Integrity Gotcha. It > >> will not allow you to create countries since > >> statesarticles does

Re: Exporting/Importing Databases

2004-06-03 Thread Egor Egorov
David Blomstrom <[EMAIL PROTECTED]> wrote: > --- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: >> At 20:36 -0700 on 06/02/2004, David Blomstrom wrote >> about >> Exporting/Importing Databases: >> >> >Third, my practice database inc

Re: Exporting/Importing Databases

2004-06-02 Thread David Blomstrom
--- "Robert A. Rosenberg" <[EMAIL PROTECTED]> wrote: > At 20:36 -0700 on 06/02/2004, David Blomstrom wrote > about > Exporting/Importing Databases: > > >Third, my practice database includes half a dozen > >tables, but only one made it online, followed by

Re: Exporting/Importing Databases

2004-06-02 Thread Robert A. Rosenberg
At 20:36 -0700 on 06/02/2004, David Blomstrom wrote about Exporting/Importing Databases: Third, my practice database includes half a dozen tables, but only one made it online, followed by this error message: Database USERNAME running on localhost Error SQL-query : CREATE TABLE `counties

Exporting/Importing Databases

2004-06-02 Thread David Blomstrom
I just got my first MySQL database online, but I have some questions. First, if I want to import a database named, say username_jack, do I have to create a database named username_jack online first? In other words, could I access an online MySQL account that's empty, with no databases, then just i

RE: Importing Fixed Length Text Files

2004-05-12 Thread Allen Weeks
Thanks for the response, it was timely and right on the money. Allen -Original Message- From: Daniel Kasak [mailto:[EMAIL PROTECTED] Sent: Wednesday, May 05, 2004 6:22 PM To: Allen Weeks; MySQL List Subject: Re: Importing Fixed Length Text Files Allen Weeks wrote: Hello All

Re: Importing Text Files in phpMyAdmin vs the Infamous

2004-05-11 Thread Stephen E. Bacher
>> I have a php website connecting to mysql database. >> How can i have a user export his database through >> the webpage to csv format? >> I would like the user to have a button he can press >> that would pop up a >> "save as" screen so he can save his database. The PHP code to do this would look

Re: Importing at command line from text file

2004-05-10 Thread Michael Kruckenberg
Robert Ameeti wrote: I'm a newbie trying to follow a tutorial. The tutorial says to type: mysql employees The employee.dat file doesn't have to be in any specific location, as long as you can read it. To run the command above, cd into the directory with the employee.dat file (maybe your home di

Importing at command line from text file

2004-05-09 Thread Robert Ameeti
I'm a newbie trying to follow a tutorial. The tutorial says to type: mysql employees <><><><><><><><><><><><><><><><><> Robert Ameeti The church is near but the road is icy; the bar is far away but I'll walk carefully. <><><><><><><><><><><><><><><><><><> -- MySQL General Mailing List For list

Re: Importing Text Files in phpMyAdmin vs the Infamous #1148

2004-05-09 Thread David Blomstrom
P.S. I should add that I'm not trying to import data between computers or to an online site. This operation involves nothing but me and my computer. __ Do you Yahoo!? Win a $20,000 Career Makeover at Yahoo! HotJobs http://hotjobs.sweeps

Importing Text Files in phpMyAdmin vs the Infamous #1148

2004-05-09 Thread David Blomstrom
Sorry, I didn't mean to send that first message; I hit send by mistake. This is the real message. I was delighted to discover how easy it is to import csv files with phpMyAdmin - until I got the following error message: #1148 - The used command is not allowed with this MySQL version I found ton

Importing Text Files in phpMyAdmin vs the Infamous

2004-05-09 Thread David Blomstrom
--- "HACKATHORN, TODD (SWBT)" <[EMAIL PROTECTED]> wrote: > Don't know if this will help, but this is how I > offer web clients to "save > as excel" in cold fusion: > > > > > > the key is to change the content like above. I am > not sure how to do this > in PHP. But I am sure if you lo

Re: Importing Fixed Length Text Files

2004-05-05 Thread Daniel Kasak
Allen Weeks wrote: Hello All, Maybe I am not searching the documentation correctly or am I correct in finding there is not method of directing importing a fixed length text file into a MySQL table? I hope I just missed the reference. Could someone point me to it. Any assistance is

Importing Fixed Length Text Files

2004-05-05 Thread Allen Weeks
Hello All, Maybe I am not searching the documentation correctly or am I correct in finding there is not method of directing importing a fixed length text file into a MySQL table? I hope I just missed the reference. Could someone point me to it. Any assistance is greatly appreciated. Allen

RE: error importing date

2004-04-20 Thread Victor Pendleton
Are you exporting/importing the DDL as well? Is the column type the same for both tables? What is that column type? TIMESTAMP(14)? -Original Message- From: Fajar Priyanto To: Victor Pendleton; '[EMAIL PROTECTED] ' Sent: 4/20/04 9:16 AM Subject: Re: error importing date

RE: error importing date

2004-04-20 Thread Victor Pendleton
M Subject: Re: error importing date -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes, I use the mysqldump command without any arguments. But, by the way, the timestamp is timestamp(10), is it correct? On Tuesday 20 April 2004 09:38 pm, Victor Pendleton wrote: > Are you exporting/importing the DDL

Re: error importing date

2004-04-20 Thread Egor Egorov
Fajar Priyanto <[EMAIL PROTECTED]> wrote: > > Hi all, > I encounter this error when importing database from one mysql server into=20 > another: the date imported is wrong. The type is timestamp. > > In the dump file, the date is : 0404121921, but when imported, i

Re: error importing date

2004-04-20 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yes, I use the mysqldump command without any arguments. But, by the way, the timestamp is timestamp(10), is it correct? On Tuesday 20 April 2004 09:38 pm, Victor Pendleton wrote: > Are you exporting/importing the DDL as well? Is the column type

Re: error importing date

2004-04-20 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi Victor, thanks for responding. I really need help here. I export/import the database using mysqldump (for exporting), and the mysql command (for importing). One thing to be noted thought, the exported sql has correct timestamps (they're ex

RE: error importing date

2004-04-20 Thread Victor Pendleton
How are you exporting/importing the data? -Original Message- From: Fajar Priyanto To: [EMAIL PROTECTED] Sent: 4/20/04 3:51 AM Subject: error importing date -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I encounter this error when importing database from one mysql server into

error importing date

2004-04-20 Thread Fajar Priyanto
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi all, I encounter this error when importing database from one mysql server into another: the date imported is wrong. The type is timestamp. In the dump file, the date is : 0404121921, but when imported, it becomes: 0004041219. Could anybody pls

Importing data to existing system

2004-03-30 Thread Scott Haneda
In a bit of a quandary here... I have a user table and a registered serials table Table data at end of email... I have been given a large set of new data, but it is flat file, basically, it looks just like the user table, with the addition of one field called serial. Somehow, I need to take the

Importing data to existing system

2004-03-30 Thread Scott Haneda
In a bit of a quandary here... I have a user table and a registered serials table Table data at end of email... I have been given a large set of new data, but it is flat file, basically, it looks just like the user table, with the addition of one field called serial. Somehow, I need to take the

importing after mysqldump --xml

2004-03-09 Thread neal
Is there any (easy) way to import the data created by using mysqldump -xml ? I'd like to use the xml feature to export from machine A, massage the data, import into machine B XML works well for my application's needs in terms of massaging the data. Thanks, Neal Katz

Importing special characters via text file

2004-01-16 Thread Rick Dwyer
Hello all. Any help on the following matter is greatly appreciated. I tried to import a text file containing numerous special characters (À, Æ, Ç , etc.) but they convert to incorrect characters. I can paste them and write them correctly using a form submission created with LP6. However, an

mysql dump file not completely importing

2004-01-15 Thread Jeff Surcess
Hi, As my database has grown I have found that the dump isn't completely restoring to my development machine (XP Pro). The file is now up to about 30 MB but it only imports about half the tables. The command I'm using to restore the db is: d:\mysql\bin\mysql.exe -h localhost -u username -ppas

Re: Importing a dumpfile

2004-01-13 Thread Roger Baklund
* Matthew Stuart > Right having just got to grips with the mysqldump command, I would like > to be able to know how to import the database back in to MySQL should > anything happen to my PC. Good thinking. :) > Does mysqlimport have to be done in the command line window like > mysqldump, and if s

Re: Importing a dumpfile

2004-01-13 Thread Douglas Sims
Hi Mat mysqldump produces files containing SQL statements. mysqlimport allows you to load data from comma-delimited (or other) text files. For example, the following line will dump the contents of the table 'goat_painters' in the database 'the_goat_database' into a file called 'goat_painters.

Re: Importing a dumpfile

2004-01-13 Thread Daniel Kasak
Matthew Stuart wrote: Right having just got to grips with the mysqldump command, I would like to be able to know how to import the database back in to MySQL should anything happen to my PC. Does mysqlimport have to be done in the command line window like mysqldump, and if so, how? It's just th

Importing a dumpfile

2004-01-13 Thread Matthew Stuart
Right having just got to grips with the mysqldump command, I would like to be able to know how to import the database back in to MySQL should anything happen to my PC. Does mysqlimport have to be done in the command line window like mysqldump, and if so, how? It's just that I tried to import st

Re: Importing dates from access

2004-01-04 Thread robert_rowe
If your MySQL field is date or datetime then MySQL will store whatever date your put in the field. If you use a timestamp field then MySQL will set this field to the current datetime on an insert or update unless you specifically set it to something. See this section of the manual for more inf

Re: Importing dates from access

2004-01-04 Thread Daniel Kasak
Matthew Stuart wrote: I have an access db with populated fields, some of them are date fields. One is a created date and another is a updated date. I haven't tried it yet, so I am not sure what I will get but I assume that if I am asking MySQL to automatically update these fields rather than m

Importing dates from access

2004-01-04 Thread Matthew Stuart
I have an access db with populated fields, some of them are date fields. One is a created date and another is a updated date. I haven't tried it yet, so I am not sure what I will get but I assume that if I am asking MySQL to automatically update these fields rather than manually have to fill th

Re: Strange performance problem importing dumped data (3.23.58 on FreeBSD 5.2-RC1)

2003-12-23 Thread michael_muir
I have found that by dumping with --extended-insert, the subsequent import is MUCH faster. Of course it only issues 450 odd queries for the data set instead of ~200k... -mike [EMAIL PROTECTED] 12/23/03 05:02 PM To [EMAIL PROTECTED] cc Subject Strange performance problem importing

Strange performance problem importing dumped data (3.23.58 on FreeBSD 5.2-RC1)

2003-12-23 Thread michael_muir
I am using 3.23.58 (server and client) on FreeBSD 5.2-RC1 and all of what I am about to describe is being performed locally. When importing dumped data (with something like mysql dbname < dbname.dump) the import is being performed at ~60 queries a second. This is MUCH slower than when I

Re: Importing Data into MySQL

2003-12-19 Thread Michael Stassen
column definitions... In that case, simply leave ID out of the columns you are importing to have mysql automatically fill in the ID with unique values. That's the point of AUTO_INCREMENT. The AUTO_INCREMENT column gets a unique number assigned by mysql if you leave it out or if you assign i

Importing Data into MySQL

2003-12-19 Thread Bob Cohen
Sorry in advance for the dumb newbie question but . . . I'm using a content management system and want to avoid the hassle of entering data by hand when I've already got it in a delimited text file. I get the basic concept of using mysqlimport. However, the source file's data doesn't match the ta

Re: Can I use TAB delimiters for importing CSV

2003-12-08 Thread Duncan Hill
om/doc/en/mysqlimport.html 4.9.9 mysqlimport, Importing Data from Text Files -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can I use TAB delimiters for importing CSV

2003-12-08 Thread Matthew Stuart
Am I able to specify to somebody who is dumping from Oracle to use TAB as the delimiter? Does MySQL enable me to specify during import that the CSV is a TAB delimited file? What do most of you use that would not cause problems with text heavy dumps? Double quotes and comas etc are used through

RE: Importing data

2003-12-05 Thread Jay Blanchard
[snip] How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. [/snip] What format is the table structure in? As for the data it should be fai

Importing data

2003-12-05 Thread Binay
Hi all, How can i import table structure and data which is there in a text file to database say test_database using phpmyadmin. I m asking using phpMyadmin as i don have shell access and hence can't use mysql commands. Plz help me ... its very urgent .. Thanks in advance Binay

Re: [OT] Importing content from Word

2003-12-02 Thread Dan Nelson
In the last episode (Dec 02), Matt MacLeod said: > I'm building a recruitment website using PHP and mySQL and would like > to be able to search CVs/resumes that people have uploaded to the > server. Most people have them in Word format - what I'd like to be > able to do is copy the text of the docu

[OT] Importing content from Word

2003-12-02 Thread Matt MacLeod
Hi, I'm building a recruitment website using PHP and mySQL and would like to be able to search CVs/resumes that people have uploaded to the server. Most people have them in Word format - what I'd like to be able to do is copy the text of the document and insert it into a mysql database so that

Re: Importing Data

2003-10-30 Thread Roger Baklund
* Trevor > after a bit of help on how to import data from a pastel > accounting database into mysql, i also need to remove some lines > out of the pastel txt file before importing into mysql You are defining your new problem to be something to be sorted out before mysql is involved, in w

Importing Data

2003-10-30 Thread Trevor
Hi All after a bit of help on how to import data from a pastel accounting database into mysql, i also need to remove some lines out of the pastel txt file before importing into mysql eg 1 "*PC\CC-ABS533 ","COMPUCON Abacus Celeron/Pentium PC ",0,0,0,0,0,0,0,0,0,0,0,0,0,0,

Importing data into MySQL

2003-09-02 Thread Darryl Hoar
I have data that is in a progress database. I need to get a copy of the data into my mysql database. What would be the best approach ? I can dump the data in any specific format, so. Never tried ODBC with Progress (8.2C12), so don't know if that can/will work. thanks, Darryl -- MySQL Ge

Re: importing Access databases

2003-07-28 Thread Bob Ramsey
I saw a macro for access that will produce a script that will recreate your tables and the data in them. But it only worked in older versions of access. Sorry I can't be more help. bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lis

Re: importing Access databases

2003-07-28 Thread Andreas
Robert Morgan wrote: Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. Depends how big the whole thing is as well as how good the current design is. Since it is running in a hospital I hope the Access approach was propperly done a

RE: importing Access databases

2003-07-28 Thread electroteque
there is an app called sqlyog it imports access directly into mysql -Original Message- From: SpamBox [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 7:13 AM To: Robert Morgan; mysqllist Subject: Re: importing Access databases Robert Morgan wrote: >Hi, I'm doing a proje

Re: importing Access databases

2003-07-28 Thread SpamBox
Robert Morgan wrote: Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from

Re: importing Access databases

2003-07-27 Thread Jim McAtee
Why does the client doing the importing need to run on Linux? Don't you have access to a Windows machine anywhere on the network? It shouldn't matter where the target MySQL server is or what OS it's running on. - Original Message - From: "Robert Morgan&quo

Re: importing Access databases

2003-07-27 Thread Sanya Shaik
--- Robert Morgan <[EMAIL PROTECTED]> wrote: > Hi, I'm doing a project for a local hospital, they > want to migrate their access databases to mysql on a > Linux box. The hospital runs a Windows network and I > have MYsql running on a linux box connected to the > network. I need to import the Access

importing Access databases

2003-07-27 Thread Robert Morgan
Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from the windows server to

importing access.mdb

2003-07-25 Thread Robert Morgan
Hi, I'm doing a project for a local hospital, they want to migrate their access databases to mysql on a Linux box. The hospital runs a Windows network and I have MYsql running on a linux box connected to the network. I need to import the Access .mdb data and structure from the windows server to

Re: Importing delimited text files

2003-07-21 Thread Paul DuBois
At 21:04 -0600 7/21/03, Jim McAtee wrote: What tools are available for importing delimted text files into MySQL tables? I've got several very large, but simple (just seven columns of integer and varchar) text files to import into a table. Use the LOAD DATA statement or the mysqlimport command

Importing delimited text files

2003-07-21 Thread Jim McAtee
What tools are available for importing delimted text files into MySQL tables? I've got several very large, but simple (just seven columns of integer and varchar) text files to import into a table. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubs

Re: importing data

2003-05-30 Thread Nils Valentin
Sorry hit the wrong reply button ;-) > Hi Rajendra, > > In case you are new to mysql the easiest way would be to do it on the > command line base : > > 1) shutdown the server > 2) go to your data directory f.e /var/lib/mysql/dbname1 > 3) copy the table files to the folder of dbname2 > > f.e c

Re: importing data

2003-05-30 Thread Rajendra Kumar
Hello Sir, thanks for the reply. i have one more doubt. i want to import 2 tables from one database to another database like the tables structure and as well as its records. have a nice day, Naren. --- Egor Egorov <[EMAIL PROTECTED]> wrote: > Rajendra Kumar <[EMAIL PROTECTED]> wrote: > >

Re: importing data

2003-05-29 Thread Egor Egorov
Rajendra Kumar <[EMAIL PROTECTED]> wrote: > > i know little bit about mysql. i use mysql to use > the webportal system of phpnuke. can anyone help me > to import data in mysql. for exams i have a file > nuke.sql which contains like tables design and there > records. > > how to call this file w

importing data to tables

2003-05-29 Thread Rajendra Kumar
Hello List, i am new to mysql. i use php-nuke web portal. i have a database.sql file which contains my database. it contains tables & there records in .sql file which can be opened with notepad. if i do a fresh installation of mysql how do i recover my database using my backup file. i mean how

importing data

2003-05-29 Thread Rajendra Kumar
Hello List, i know little bit about mysql. i use mysql to use the webportal system of phpnuke. can anyone help me to import data in mysql. for exams i have a file nuke.sql which contains like tables design and there records. how to call this file when i am having sql prompt. i use redhat lin

Re: what is the best data format to start with when importing data into mysql?

2003-05-27 Thread James Moe
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tue, 27 May 2003 11:17:34 +0200, Emiliano Rustighini wrote: >I can ask for the data in any data format, but I would like to get some >advice on what is best to ask for. > I have found text format to be the most flexible method for transferring be

Re: Importing into an AutoIncrement field

2003-03-21 Thread Paul DuBois
At 22:28 -0600 3/21/03, Paul DuBois wrote: At 20:04 -0800 3/21/03, Todd Cary wrote: I would like to avoid the necessity of specifying all of the fields - instead use the following syntax: INSERT INTO teachers VALUES (1,12345,NULL,'Harry','Smith','707-773-4523',2',... However, the first field is a

Re: Importing into an AutoIncrement field

2003-03-21 Thread Paul DuBois
values go in which clients. If you specify an explicit value for the auto-increment column (as you do above), and the value already exists in the table, you'll get a duplicate key error, assuming that you've declared it as a PRIMARY KEY or UNIQUE index. The next is question is the command l

Importing into an AutoIncrement field

2003-03-21 Thread Todd Cary
my value and overwrite it with the "auto" value? The next is question is the command line syntax for importing a file liek the above? I have never done it and I am using the Linux version of MySQL. Todd -- Ariste Sof

Re: what's the best format option for importing SQL Server databases?

2003-03-12 Thread Gopalarathnam V.
There is one particular program that can dump an SQL Server database as SQL statements much like mysqldump--its called SqlDump and it is available from http://sqldump.sourceforge.net. Ask your client to use it to give you the SQL file. NOTE: the SQL stmts may be very much SQL Server specific tho

Re: what's the best format option for importing SQL Server databases?

2003-03-11 Thread Paul DuBois
At 14:24 -0600 3/11/03, kenn murrah wrote: Greetings. I've been challenged with an assignment in which my client will feed me a 9000-record SQL Server database every night, and I in turn will need to import the data into mySQL, replacing the mySQL database from the night before ... Given that

Re: what's the best format option for importing SQL Server databases?

2003-03-11 Thread Shamit Verma
CSV would be the easiest way. -Shamit Verma (http://vshamit.com) - Original Message - From: "kenn murrah" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 12, 2003 1:54 AM Subject: what's the best format option for importing SQL Server databas

what's the best format option for importing SQL Server databases?

2003-03-11 Thread kenn murrah
Greetings. I've been challenged with an assignment in which my client will feed me a 9000-record SQL Server database every night, and I in turn will need to import the data into mySQL, replacing the mySQL database from the night before ... Given that scenario, and the fact that I obviously wan

Re: importing data from pervasvie to MySQL

2003-03-02 Thread Maciej Bobrowski
> Hi all, Hi, > I have a database in Pervasive and I want to import it to MySQL. > I tried to convert the Pervasive data to a text file and then import it > into MySQL but it failed. > Is there any tool to do this directly? > Does MySQLCC provide any export option through which I can get the dat

importing data from pervasvie to MySQL

2003-03-02 Thread Prasanth Krishna
Hi all, I have a database in Pervasive and I want to import it to MySQL. I tried to convert the Pervasive data to a text file and then import it into MySQL but it failed. Is there any tool to do this directly? Does MySQLCC provide any export option through which I can get the data from Pervasive?

Re: importing database

2003-02-11 Thread Simon Windsor
Hi There are many ways to convert an Oracle DB to MySQL. 1 - Scan, process Oracle exp files, very painful 2 - Use a tool that can access both databases, ie Excel via ODBC 3 - Access oracle schema tables, user_tables, user_tab_columns, user_objects etc and create a MySQL SQL file. The third appr

importing database

2003-02-10 Thread rajesh
my previous database was ORACLE8 IN WHICH THE BACKUPS ARE .DMP FILES PLEASE HELP ME TO CONVERT THAT INTO MYSQL DATABASE PRATHIMA RAO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://

Re: FreeBSD: MySQL crash when importing 148 MB dumpfile

2003-01-18 Thread Ken Menzel
CTED]> Sent: Friday, January 17, 2003 6:28 PM Subject: FreeBSD: MySQL crash when importing 148 MB dumpfile > Problem: I am migrating servers, from a dual PIII-866 Mhz with 384 MB of > RAM running Linux to the following server configuration: > > Dual Athlon 1.5 Ghz > 1 GB RAM &g

FreeBSD: MySQL crash when importing 148 MB dumpfile

2003-01-17 Thread Maximo Migliari
nal <_final.sql ERROR 2013 at line 1814: Lost connection to MySQL server during query [root@server1 admin]# 030117 17:02:55 mysqld restarted I have attempted this on both: MySQL-Max-3.23.54a and the latest MySQL 4 gamma release for FreeBSD. When importing other databases, it works fine, but fo

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread Markus Warg
Lars, uhm, installed that package and it confirms your suspicion: Total memory: 612 Megabytes Kernel Memory: 60 Megabytes Application: 89 Megabytes Executable & libs: 32 Megabytes File Cache: 419 Megabytes Free, file cache: 6 M

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread Lars Heidieker
Hi Markus, I just missed something in your original Mail, I guess its not the mysql server growing to 1gig (check with ps -ely) its simply the system memory showing no free mem. If you have root access to the maschine its probably a good idea to install the prtmem command (ftp://playground.sun.co

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread Markus Warg
Lars, the amount used increases until all free memory is used plus a fair amount of swap. On a machine with 2GB memory this can well grow up to 1GB. Any chance to get the current size of the malloc pool to check if this causes the effect? thx so far, Markus On Don, 21 Nov 2002, Lars Heidieker

Re: mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread Lars Heidieker
Does the memory amount used increases any further if repeating the dump import. If so there is a leak if not you just got fooled by the standard malloc of solaris which wont return memory free(d) to the system but instead the memory will be kept in a pool for the next malloc. Lars On Donnerst

mysql memory leak on SUN Solaris 5.7 when importing dump files

2002-11-21 Thread markus
>Description: Dump several big tables or entire databases with mysqldump, then import to same or another database with mysql -f db How-To-Repeat: Dump a database with around 250.000 to 3.000.000 records, record size is around 200 bytes. Import dump file and s

Re: importing form a file (question)

2002-11-20 Thread John Coder
On Wed, 2002-11-20 at 18:19, Stick Dragon wrote: > I had a free mysql database and admined with phpmyadmin. well i got a back > up from called backup.sql > > in side the file it looks like this > > # Table structure for table `phpbb_auth_access` > # > > CREATE TABLE phpbb_auth_access ( > grou

Re: importing form a file (question)

2002-11-20 Thread Daniel Kasak
Stick Dragon wrote: I had a free mysql database and admined with phpmyadmin. well i got a back up from called backup.sql in side the file it looks like this # Table structure for table `phpbb_auth_access` # CREATE TABLE phpbb_auth_access ( group_id mediumint(8) NOT NULL default '0', forum_i

importing form a file (question)

2002-11-20 Thread Stick Dragon
I had a free mysql database and admined with phpmyadmin. well i got a back up from called backup.sql in side the file it looks like this # Table structure for table `phpbb_auth_access` # CREATE TABLE phpbb_auth_access ( group_id mediumint(8) NOT NULL default '0', forum_id smallint(5) unsigned

Re: importing from text: date column problem

2002-11-15 Thread Gelu Gogancea
[EMAIL PROTECTED] - Original Message - From: "Bran Ioan" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, November 16, 2002 1:55 AM Subject: importing from text: date column problem > I want to import a text file into a table that has a date type colu

importing from text: date column problem

2002-11-15 Thread Bran Ioan
I want to import a text file into a table that has a date type column with mysqlimport. In the text file the date column is in the DD-MMM-YY format (ie 25-JUL-02); so when I import it, I get -00-00 in the table's date column. Is there a way to do this correctly ? My version is 3.23.52. Thank y

Re: Problem importing data from Access

2002-11-06 Thread John Ragan
try this: 1. export the data from ms access to a file on the windows box. 2. fire up ftp from the command line and set it to ascii mode. 3. ftp the file from the windows box to the linux box. if the eol is the problem, the ftp protocol will insure that the eol is correctly translated wh

RE: Problem importing data from Access

2002-11-06 Thread Schroeder, Bradley (Contractor)
- From: Gelu Gogancea [mailto:ggelu@;arctic.ro] Sent: Wednesday, November 06, 2002 1:02 PM To: Schroeder, Bradley (Contractor); 'Black, Kelly W [PCS]'; [EMAIL PROTECTED] Subject: Re: Problem importing data from Access Hi, You must use a HEX editor to see this characters which are not printa

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
uot; <[EMAIL PROTECTED]>; "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 2002 9:41 PM Subject: RE: Problem importing data from Access > The text

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
[EMAIL PROTECTED] - Original Message - From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>

RE: Problem importing data from Access

2002-11-06 Thread Schroeder, Bradley (Contractor)
-Original Message- From: Black, Kelly W [PCS] [mailto:kblack05@;sprintspectrum.com] Sent: Wednesday, November 06, 2002 12:34 PM To: 'Gelu Gogancea'; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: RE: Problem importing data from Access This is incorrect. !google &

RE: Problem importing data from Access

2002-11-06 Thread Black, Kelly W [PCS]
This is incorrect. !google "new line character" linux windows -Original Message- From: Gelu Gogancea [mailto:ggelu@;arctic.ro] Sent: Wednesday, November 06, 2002 11:33 AM To: Black, Kelly W [PCS]; Schroeder, Bradley (Contractor); [EMAIL PROTECTED] Subject: Re: Problem importing

Re: Problem importing data from Access

2002-11-06 Thread Gelu Gogancea
PROTECTED] - Original Message - From: "Black, Kelly W [PCS]" <[EMAIL PROTECTED]> To: "'Gelu Gogancea'" <[EMAIL PROTECTED]>; "Schroeder, Bradley (Contractor)" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, November 06, 20

<    1   2   3   4   5   >