Re: best way to copy a innodb table
Well, the easy way to chunk the inserts is by use of limit. Here is what I used for one of my projects: Insert ignore into t1 (f1, f2, f3) Select f1, f2, f3 from t2 limit 100, 100 Inserts 1M records at a time starting from 1M th record in t2 and you can keep incrementing this offset as you progress. This will help in monitoring the table inserts and at the same time move chunks of records from source table. Enjoy! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
transitioning from ms sql
Hi, I have been using MS SQL for the last one year, however would not like to transition to mysql. At the first glance it looks very different from ms sql and the tools are also different. can someone tell me if there is any document which explains the equivalence and how i could port a lot of my queries, tables, views and stored procedures to my sql from ms sql. Best Regards, Arjun ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any unauthorized use of the information contained in this email or its attachments is prohibited. If this email is received in error, please contact the sender and delete the material from your computer systems. Do not use, copy, or disclose the contents of this email or any attachments. Abu Dhabi Investment Authority (ADIA) accepts no responsibility for the content of this email to the extent that the same consists of statements and opinions made which are the senders own and not made on behalf of ADIA. Nor does ADIA accept any liability for any errors or omissions in the content of this email caused by electronic and technical failures. Although ADIA has taken reasonable precautions to ensure that no viruses are present in this email, ADIA accepts no responsibility for any loss or damage arising from the use of this email or its attachments. **
Migrating Access databases to MySQL
Hello people ! I was hoping for some wisdom from the good folks on this list about moving databases from access to MySQL. I am aware of the brute force method of exporting in CSV format or tab delimited formats and using mysqlimport to move the tables. 1. I was wondering if there was a way to dump access databases in SQL queries like the mysqldump utility does ? 2. When exporting tab delimited values from access and using mysqlimport everything works fine except date columns. All the data moves except the date field which shows up zero's I mysql after I use mysqlimport. Does anyone have a clue on what might be happening? 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I would appreciate any help at all. Thanks to everyone in advance ! Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Casey Sheridan [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 6:32 PM To: [EMAIL PROTECTED] Subject: writing queries to get distinct results I have a table that has employee names, pay rates, and unique IDs. I want to select all of the distinct employee names, and if there are two employees with the same name, I want to be able to choose only one; the one with the highest pay rate. If there are two identical employee names with the same pay rate, I want to select the one that has the lowest unique ID number. Can anyone help me on how to write this query? Thanks! -Casey Sheridan [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Migrating Access databases to MySQL
Hi bob ! thanks for your quick reply. I did do a search on google. I bumped into a bunch of stuff that really lead nowhere. Do you have any specific sites or utilities in mind ? Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 I'm MySQL certified. Are you? -Original Message- From: Bob Ramsey [mailto:[EMAIL PROTECTED] Sent: Thursday, March 18, 2004 9:07 PM To: Arjun Subramanian Subject: Re: Migrating Access databases to MySQL Arjun Subramanian wrote: 3. Is there any way other than downloading some shareware third party programs to transfer my databases from access to MySQL ? I have seen free macros that create a text file you can import into mysql; it creates the tables and inserts all of your data. Do a google search, and if you still can't find anything let me know. bob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql database, user table, two root accounts
That's not two root accounts. What that means is this: The first line defines privileges for root connecting from localhost The second line defines privileges for root connecting from any remote host. Hence the %. It implies [EMAIL PROTECTED] Hope this helps. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Leo Donahue [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 2:47 PM To: [EMAIL PROTECTED] Subject: mysql database, user table, two root accounts I am less than 24 hours new to MySql. I have executed the following sql scripts: use mysql; delete from user where User=''; delete from db where User=''; flush privileges; select host, user, password from user; The last sql query yields the following: hostuserpassword - localhost roothexadecimal values. % rootnothing here. Why are there two root accounts? Thanks, ld -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Certification Question
I took the MySQL core certification exam on the 2nd of January and Passed. I was just wondering when MySQL actually sends out the Certificate and other stuff they said they would send out? Does anyone here have any experience with this ? Thanks in advance. Arjun Subramanian Georgia Tech Station 32003 Atlanta GA 30332 Cell: +404.429.5513 http://www.arjunweb.com -Original Message- From: Amanullah [mailto:[EMAIL PROTECTED] Sent: Friday, January 09, 2004 10:03 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: New INstall of MySQL Hi, make sure the existing directories has been removed fully, then continue with new installation, after installation is over, pl. restart the system, if mysql daemon has not started, pl. go to ..\mysql\bin\ directory run winmysqladmin.exe. mysql service will be strated to work.. -Aman. Chris L. White wrote: Ok I have a question. This is the first time any of us here in our office have installed MySQL or for that fact worked with MySQL. So I got stuck with trying to figure it out. Ok here is the problem. I completely removed the previous MYSQL installation attempt. I started new to install MYSQL. I go to setup and run the setup and the status bar does not move much and the installation takes about 5 seconds and then it is done. I get to the finished installing screen, but there are no options to choose from like the test in the screen says there should. Also I have a my.cnf and ny.ini file in the proper places and I still have nothing going. I am confused and the manual I am finding is not clear enough on this. I included what the my.cnf and my.ini file looks like. And also included the error I am getting after installation. Also after MYSQL is installed should there not be some icons for things related to it, because I don't even have them. I am trying to install this on 2003 Server Standard Edition and have IIS 6 and TCP/IP installed. Please help. [mysqld] # set basedir to your installation path # basedir=C:/mysql # set datadir to the location of your data directory #datadir=C:/SQLData # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/SQLData # Uncomment the following if you are NOT using BDB tables skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables #innodb_data_file_path = ibdata1:400M #innodb_data_home_dir = c:\ibdata #innodb_log_group_home_dir = c:\iblogs #innodb_log_arch_dir = c:\iblogs #set-variable = innodb_mirrored_log_groups=1 #set-variable = innodb_log_files_in_group=3 #set-variable = innodb_log_file_size=5M #set-variable = innodb_log_buffer_size=8M #innodb_flush_log_at_trx_commit=1 #innodb_log_archive=0 #set-variable = innodb_buffer_pool_size=16M #set-variable = innodb_additional_mem_pool_size=2M #set-variable = innodb_file_io_threads=4 #set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout C:\MySQL\binmysqld --console 040109 9:53:02 InnoDB: Started 040109 9:53:02 Fatal error: Can't open privilege tables: Table 'mysql.host' d esn't exist 040109 9:53:02 Aborting 040109 9:53:02 InnoDB: Starting shutdown... 040109 9:53:04 InnoDB: Shutdown completed 040109 9:53:04 mysqld: Shutdown Complete Chris L. White Network Administrator Coe-Truman Technologies, Inc. Email: [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com
Re: Newbie: need form to input records View report
If you want to build something like a web form you will need to use HTML and a scripting language. A common solution to do what you are asking is to use PHP. You will need to be familiar with PHP to go further. Go to http://www.php.net to get a hold of the basics. There is no way to write a walkthrough for your problem here as it would be quite long :o). It would also be repititive since there are millions of sites that provide such walkthroughs. Go to www.sitepoint.com, which is a web dev portal. My favortite. They have tons of usefull articles and step by step walkthroughs. From a big picture point of view what you need to do is use PHP to generate HTML dynamically and handle application logic, database interactivity. Use the MySQL database as your data store [obviously ;)]. PHP is an excellent choice as it works very well with MySQL. If this sounds like greek then don't worry too much. Head to sitepoint.com and go to the php section and start learning. It is an excellent resource. PHP.net is a good place too although you might want to go to sitepoint first. Best of luck, Arjun Quoting Troy T. Hall [EMAIL PROTECTED]: I know this sounds stupid but I'm totally lost. I've created a MySQL DB whose purpose is to track customers who have not gotten a newspaper. I've created all the necessary fields, and have managed to learn how to add/delete/modify the records in mysqlcc, but what I want is to have a predesigned form like you'd find on a webpage where you simply enter the complaints and hit submit or whatever, and it responds with the complaint ID # ( ComplaintID is an autoincrement field in the db ) Then I need to be able to print a report in a nicely labeled/readable format showing all entries made that day where the chargeable field is not List (Chargeable is an enum consisting of yes, no, list). Will someone please be kind enough to point me in the right direction. I can't seem to get my head around this concept. Troy oh, if it matters, I'm using Linux Mandrake 9.2 with the Gnome 2.0 GDM. I also have qtDesigner, OO, Screem. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Core Certification
Hello everybody ! I have question regarding the MySQL core certification. Does anybody have any general insights on taking the exam ? I am studying from the manual, but I am pretty nervous about the exam as I don't know how much in depth the questions will be or even if studying from the manual alone will be sufficient. I would appreciate any thoughts or comments from anyone about the exam.Thanks ! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]