Convert database


Login or Register for Dates, Times and to Reply

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Convert database
# 1  
Convert database

We use the MS access database, I want to convert the database to mysql db , could suggest is there any tools / methods that I can export the table and data from access , and import it to the new mysql db ? thx in advance.
# 2  
Doesnt MS-Access have an export tool built in? If so use it to create a delimited file. Otherise you can write a VBA procedure to select all rows from a table and dump it into a delimited file on your PC. I dont know MySQL but am familiar with Oracles tools. Oracle has a utility called SQL*Loader that imports datasets from a flat file into the database. Look for something similar.
# 3  
If your table structures aren't changing, you could simply unload each access table as a tab delimited file and import them into their MySQL equivalent:

load DATA LOCAL INFILE "<filename>" INTO TABLE <tablename>;

Cheers,

Keith
# 4  
thx reply , how about the table structure ? how to load the table structure of access to mysql ? thx
Login or Register for Dates, Times and to Reply

Previous Thread | Next Thread
Thread Tools Search this Thread
Search this Thread:
Advanced Search

Test Your Knowledge in Computers #508
Difficulty: Easy
A variable is basically a memory location in which a value can be stored.
True or False?

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

CRON Job to copy database and replace existing database

I have a reseller account with hostgator, which means i have WHM and Cpanel. I have set up a staging environment for one of my wordpress installations (client website), which is essentially sitting at staging.domain.com (live site is at domain.com). The staging website is a complete copy of the... (1 Reply)
Discussion started by: nzrobert
1 Replies

2. Solaris

Can't create database after Oracle Database installation

I installed Oracle 10 software on Solaris 11 Express, everything was fine execpt I can't create database using dbca.rsp file. I populated file with following options. OPERATION_TYPE = "createDatabase" GDBNAME = "solaris_user.domain.com" SID = "solaris_user" TEMPLATENAME = "General... (0 Replies)
Discussion started by: solaris_user
0 Replies

3. Solaris

redirect solaris database from linux database..

hi.. i have a need .. my php runs on my linux redhat box with mysql.. i want my php code to refer another mysql database which is in solaris 10 x86... can u tell me the procedure .. how it can be done through php .. sorry am new to php... is it possible to redirect from linux mysql to... (7 Replies)
Discussion started by: senkerth
7 Replies

4. Programming

database in C

how can we connect to database(psql) using c language?. Any one help.Pls say the hader file and function's avilable in C for database operation(like connecting,selecting,etc...). (3 Replies)
Discussion started by: sabari
3 Replies

5. Linux

Database

Hai , can any one suggest me any site where the mysql tutor for linux is avialable i am new to the linux mysql so i want to know right from the basics and how can i connect those database to planner tool in linux :) Regards Sanju (1 Reply)
Discussion started by: sanjustudy
1 Replies

6. Programming

AGAIN database

THis is my program #include <stdio.h> #include "sqlext.h" #include "sql.h" #include <string.h> #include<errno.h> // #include "sqlunix.h" #define STR_LEN 30 #define SQL_NTS (-3) #define MYSQLSUCCESS(rc) ((rc==SQL_SUCCESS)||(rc==SQL_SUCCESS_WITH_INFO)) ... (8 Replies)
Discussion started by: ramneek
8 Replies

7. Shell Programming and Scripting

here-doc convert 2 script convert to single script?

I have my main script calling another script to retrive a "ls -alt" of a directory that's located in a remote location I'm sftping into. main.sh #!/bin/ksh getLS.sh > output.txt getLS.sh #!/bin/sh /home<..>/sftp <host@ip> <<! cd /some/dir/Log ls -alt quit ! Basically I'd like to be... (2 Replies)
Discussion started by: yongho
2 Replies

8. UNIX for Dummies Questions & Answers

Database

I am looking for a database that i can use on Red Hat Linux 8.0. I wish to store records about my clients in it. I do not wish for i to be used on a server (3 Replies)
Discussion started by: adminbw
3 Replies

9. Programming

help in using database in c++

help me in using database in c++ whether datas entered in c++ can be stored in Oracle or access database? give a hint (1 Reply)
Discussion started by: sajin_george
1 Replies

Featured Tech Videos