Migrating Access databases to MySQL

2004-03-18 Thread Arjun Subramanian
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

2004-03-18 Thread Arjun Subramanian

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

2004-01-09 Thread Arjun Subramanian
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

2004-01-09 Thread Arjun Subramanian
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