MySQL Forums - Other Migration

import berkeley db (no replies)

zhou tao — Mon, 23 Nov 2009 07:42:13 +0000

Hi,

Is there any way to query and edit entries of a berkeley db file?
I am configuring postfix with sasl authentication and I think it would be much convenient if I can use mysql to add or delete accounts instead of saslpassword.
any answer would be appreciated.

Bruce.

Generic bulk data load (no replies)

John Dunn — Tue, 17 Nov 2009 10:57:01 +0000

Is there a generic high performance way to bulk load data into a database table from a text file without using vendor specific tools? I need to bulk load data into both Oracle and MYSQL

MS Visual FoxPro to My SQL migration (1 reply)

Debduti Sengupta — Mon, 09 Nov 2009 10:53:05 +0000

Hi,

I have MS Visual FoxPro installed on my system. The data volume is not very huge.
I want to migrate to My SQL .
Can someone please let me know the step by step procedure for this?
Also, please let me know how much the front end applications need to be modified.
Please note that I am not very familiar with either FOXPRO or MYSQL (so I shall need some guidance right from installation procedure).
Thanks for letting me know.

Debduti

problems with import from *.txt file (1 reply)

Bartek Cieslak — Tue, 10 Nov 2009 13:11:41 +0000

Hi
I have a problem
I want to add to my database information. It is marked as varchar so I have to use ' ' before and after an information, but my exported file has no ' ' for example

text to need in db: 'sample text'
text in my *.txt file: sample text

how can I convert it or make it happen that my text will recieve before and after the text ' '

Migration of postgresql to mysql (2 replies)

Mahendra Bagul — Mon, 02 Nov 2009 07:47:53 +0000

Hi,
I want to migrate our database from postgresql to mysql.If you know any migration tool or any methodology then please reply.......

Running into trouble with Importing CSV containing comma (no replies)

vdfk vdfk — Mon, 26 Oct 2009 13:58:48 +0000

I'm a mySQL newbie so please excuse my ignorance and abundance of questions.

I'm having trouble importing a .csv extract into a table via mysqlimport command. Below is the command I use...

mysqlimport --host=localhost --user=root --password=testing1 --fields-terminated-by="," --lines-terminated-by="\r\n" aexworkflow c:\csvimport\aexextractraw.csv

When I run the statement above, i receive the below error...

mysqlimport: Error: 1262, Row 5 was truncated; it contained more data than there
were input columns, when using table: aexextractraw

I know why this error occurs. Its because I have a column in my extract that has a comma inside its content. How can I make mySQL ignore this comma when importing?

One way I can think of avoiding it is to convert the delimiter on the .csv file from "," to "|". However, that will require me to search and replace manually. Is there an automated way of converting .csv files to pipe delimited? Could I possibly schedule this conversion as I plan to automatically download this .csv extract every hour or so?

I've searched the forums and the web for hours but I cannot find a solution to this issue. Any help or guidance is appreciated. Thanks

-vdfk

New open source data synchronization tool (1 reply)

af dabler — Fri, 16 Oct 2009 12:04:10 +0000

Hello,

We are trying to find an ETL tool open source. Basically, we need our software to perform ETL, data migration and data synchronization.

The program should not be used on larger projects. A few open source tools exist on the market.

Some ideas? Thanks.

Problem integrating SSRS 2008 with MYSQL (no replies)

pradeep pradeep — Fri, 25 Sep 2009 09:48:48 +0000

Hi,

I would really appreciate any help for this problem.

Basically I am using SSRS 2008 for reporting services. My first choice of DB was MYSQL. So I installed ODBC MYSQL connector and created a DSN and used it in report design. If I preview the report in the Business Intellgence Dev Studio, I can see the records, but when I try to view in the local URL
http://mycomputername:port/Reports

it says , DataSource1 not found or driver not installed.

Can anyone please tell me if this is the problem with SSRS configurations or Do I need to make any changes further to make it work in a URL based scheme?

TIA.
Pradeep.

Isue with Decimal datatype and auto increment (no replies)

vijayanand kalyanaraman — Thu, 24 Sep 2009 00:52:49 +0000

Hi,
I am migrating data from Oracle to My sql database
I have fields whose datatype is number(38,0) in oracle. Upon migration the fileds data type is Decimal(38) in My sql. But i am unable to set Auto increment flag for this field. Changing to bigint will not work as its max size is limited to 20 digits. Have tried binary datatype as well, but not able to flag that coulum as auto increment

Please advise
Thanks,
Vijay

xkeyed or mkeyed files (2 replies)

nvt nvt — Tue, 06 Oct 2009 18:37:14 +0000

how can i connect mysql directley to xkeyed or mkeyed files as a sort of data dictionary without using basis.com bbj?

regards

MySQL Windows to Linux Migration issue (no replies)

ad ade — Tue, 22 Sep 2009 20:51:43 +0000

Hello Everyone,

I am trying to setup a new infrastructure for Apache/PHP/MYSQL, all currently are Windows Server and I am migrating to CentOS in a load balancer enviroment. Everything works however, I am having an annoying problem which I am fighting for few hours now. When I migrate a database over from the Windows server to the Linux Server I am getting bad characters. I have tried character sets and collation on the database but dint help.

below is an example:

it's (On the old server)

It�s (on the new server)

I have tried mysqldump ----default-character-set=latin1 and then imported the the database but I got the following results.

The solution i tried was from this link http://www.orthogonalthought.com/blog/index.php/2007/05/mysql-database-migration-and-special-characters/

it?s (it changes an apostrophy tp a question mark?)

I am running out of ideas because I have also tried copying raw files from server tp server and still the same issue.

Does anyyone what is cusing this character change, i know that defaults backups are UTF8 and i tried changing them using the --default-character-set switch.

Do i need to change my character set global parameter?

FYI these are joomla websites, if that makes any difference. Any help is greatly appriciated.

Thanks,

Adel

Moving MySQL Data from Linux to Windows Computer (1 reply)

Dan Ford — Fri, 04 Sep 2009 11:24:43 +0000

The Paradigm

I recently was finally given a computer for work, which runs on Windows XP. I had previously been working using my personal Linux laptop, and had developed several MySQL/PHP applications to aid in data entry and SQL reporting, all of which ran on localhost. I use an "include" file to establish my connection, and run SQL inserts and updates via localhost. Ran like a champ in Linux.

The Problem

I installed WAMP Server (www.wampserver.com) on the new computer, and have now moved my data from the Linux laptop to the WinXP laptop. I actually did that pretty easily, but now, I find that I cannot connect using the username and password combinations. I tried to replicate them EXACTLY on the WinXP box, but no joy in Mudville, as they say.

The Parameters

Set up a very simple table:

id color employee
------------------------
1 Red Dan
2 Blue Mike
3 Yellow Cindy
4 Orange Gerri
5 Purple Rick
6 Green Crystal

Here's a copy of my "connection.php" file:

-----BEGIN PHP CODE-----
$db = mysql_connect("localhost", "xploser", "xploser");
if (!$db) {
echo "error!";
}
mysql_select_db("dangoof");
-----END PHP CODE-----

The test code to see if I can run a simple query:

-----BEGIN PHP CODE-----
include("connection.php");

$query = "select * from table1";
$result = mysql_query($query);
$num_results = mysql_num_rows($result);
for ($i=0; $i <$num_results; $i++)
{
$row = mysql_fetch_array($result);
echo "

".$row["id"]." - ".$row["color"]." - ".$row["employee"]."

";
}
-----END PHP CODE-----

I've run this code a thousand times without problems, but now, I get this error message:

-----BEGIN ERROR CODE-----
Warning: mysql_query() [function.mysql-query]: Access denied for user 'SYSTEM'@'localhost' (using password: NO) in C:\wamp\www\acs\dangoof\index.php on line 5

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in C:\wamp\www\acs\dangoof\index.php on line 5

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\acs\dangoof\index.php on line 6
-----END ERROR CODE-----

I tried setting up a completely new user using PHPMyAdmin, and running it again - still no luck.

What am I missing? Are there some wacky settings in Widows XP I need to set to enable this functionality? Any insights would be greatly appreciated.

Dan sends...

A few articles of interest on MySQL (no replies)

Jayaram Krishnaswamy — Wed, 05 Aug 2009 14:04:55 +0000

In the last couple of days I have written a few articles that may be of general interest to the forum participants.

Here is a link to the articles:
http://hodentek.blogspot.com/search?q=mysql

They deal with :
Migrating a table to MySQL

Linked server on SQL Server 2008

Web enabling MySQL data with VB.NET etc

Many more are going on line in the next few days,

Data Transfer using SSIS
etc

Import Data From Excel/Open Office Writer (1 reply)

Ezekiel Macharia — Fri, 17 Jul 2009 12:52:41 +0000

I have a multiple worksheets abt (50) each packed to the brim with data, abt 3 million records

Exporting to MYSQL using CSV is a nightmare, OpenOffice (OO) only exports one sheet at a time.

ISO-8859-1 data in UTF-8 database (no replies)

Steven Le Bras — Thu, 16 Jul 2009 19:52:09 +0000

Hello,

I have to migrate a database from a 5.0 mysql community server to another 5.0 mysql but I figured out that the database has been created in utf-8 and data is in latin1 charset.
How could I migrate my database without charsets issues and without modifying the original database ? This one is on production so I don't want to go down it.

EDIT: I had forgotten : the charset goal is latin1 due to others environments encoding

Thank's

Stéven

importing xml file to mysql (1 reply)

Laura Schneiderman — Wed, 07 Oct 2009 11:59:44 +0000

I have an xml file that takes the following format:

...

I'd like to import this data into a mysql database, but I haven't seen an example of how to do that with a file structured in this way. Can you open the file, read in its contents, and load each value into a database with PHP? Is there a better way?

MySQL windows to linux migration: what are correct steps to do? (2 replies)

Tri Bao Ho — Mon, 03 Aug 2009 12:22:14 +0000

Hello,

I need to migrate the whole database (in InnoDB) from mysql (4.1) on windows to mysql on Linux. And I want to use mysql 5.1 on linux. Could anybody point me the correct steps to do?

What I have in mind is:
- Install mysql 5.0 to Linux box
- Copy the whole data file folder from Windows to Linux (the database is very big so that I think I cannot use mysqldump)
- Run mysql_upgrade on the Linux box
- Upgrade (install) mysql on Linux box to version 5.1
- Run mysql_upgrade again.

Is it the right way to go?

Thank you in advance for any feedback,
Bao.

N1NF to 1NF table conversion (1 reply)

Altaz Belim — Mon, 06 Jul 2009 14:44:28 +0000

I am migrating some data from EXCEL to MySQL, which include tables of the following form:

Person | Favorite Colors
-------- --------------------
Bob | blue, red
Jane | green, yellow, red

Which is a design that does not comply with 1NF. A more semantically correct design would be:

Person | Favorite Color
-------- --------------------
Bob | blue
Bob | red
Jane | green,
Jane | yellow
Jane | red

The real file is more complicated, with over 900 entries, making the conversion tedious. What can you suggest as a scripted solution to my problem?

error log (no replies)

Vishnuvardhan Kashipathi — Thu, 02 Jul 2009 08:46:44 +0000

Hi,
I need to capture the execution errors into a log file, is there any method by which i can achieve this. Please let me know ASAP.

Thanks in Advance...

Vishnuvardhan K.N.

Fetching data from berkeley db using Excel Macro (no replies)

Kiran K — Thu, 18 Jun 2009 11:18:22 +0000

Hi Friends,
Is there anyway to fetch data from berkeley db using excel macro.
Please help on this...

Load DATA INFILE 'file.txt' not found (Errcode:2) (no replies)

Martha Van Orshoven — Tue, 16 Jun 2009 17:57:54 +0000

I'm using a Mac and version 5.1 of MySQL.

I’m attempting to load the initial database tables with txt files.

The first one went fine and then I decided to modify it; The modified file is not being found by mysql even though an “ ls –l” at the command line shows the file there.

The original modified file, I modified and then copied to the correct path using
Sudo cp /Users/mvanorshoven/Downloads/grasstablemin.txt /usr/local/mysql/bin

The permissions on the new file read
-rw-r-r--@ 1 root wheel

My next experiment was to do an exact copy of the file that mysql was recognizing;
cp grasstable.txt grasstable2.txt

The permissions on new file read exactly the same as the old and the file size is exactly the same. However, even though I’m able to load the data from grasstable.txt into my mysql table, I can’t load grasstable2.txt

Any ideas?

Error 1045<28000>:Access Dennie for the user (no replies)

Sachin Gainewar — Mon, 08 Jun 2009 06:15:45 +0000

syntax i fallowed: mysql -u satish -h 127.101.100.35 -p

I am not able to login through user from anther m/c(getting the error of "Error 1045<28000>:Access Dennie for the user 'satish'@'127.101.100.35'"), where as when i am using the same m/c on which server is set-up with the same user logged-in successfully .

Please help me i need the solution for my project...
i emailID -sachingainewar@gmail.com

Thanks
Sachin

Faircom C-TREE database to MySQL ? (no replies)

mark bar — Tue, 02 Jun 2009 13:45:05 +0000

This is a very open question, sorry for that but I'm relatively new to MySQL
and I'm in front of a problem for which my searches on the web gave no real
answer.

It's about database files at the Faircom C-TREE format (www.faircom.com).
Faircom software is proprietary and not open source. Three is a free limited
SDK available but that's totally new for me and I'm not sure of what can be
done or not with it yet. And I have no real knowledge of C-TREE, to be
honest, only some theory.

I would like to "convert" these kind of databases to MySQL, directly or not.
I would have to do this seeveral times a year so I'm looking for a
relatively easy and automatic solution if possible.

Is there any available ready-to-use solution? (I won't be against paying a
bit for it, but our project is totally non-commercial, so we can't spend a
lot.)

Or is there any document describing in details how to achieve this?

Or at least some clear directions?

Thanks in advance. :)

Old Database recovery (1 reply)

Stephen Adshead — Tue, 14 Apr 2009 10:04:59 +0000

A friend of mine had a Win95 machine with an ancient system running on it, its finally gave up the ghost last week.

I recovered the folder containing these database files but cannot get the data out there are a mixture of file types in there that i have never encountered before including .ISD, .ISF & .ISM (I read somewhere these could be assocaited with an old version of MySql).

As well as these files i have some .rpt (which open invoice templates in Crystal Reports) and .rsf (which i suspect could also contain data).

The .ISD is the largest of all the files in the directory so i am hoping this is the one with 15 years worth of data sat in it but does anyone know how i get this information in a readable format? Have you even heard of these extensions before?

Thanks in advance for any help or advise offered.

Steve

MySql DB OS Migration (3 replies)

ashish laddha — Thu, 09 Apr 2009 11:00:25 +0000

Hi,
How to migrate MySql Database at OS level from Windows to Sun Solaris.

how to create new database from old database (no replies)

Amit Chavda — Thu, 12 Mar 2009 06:59:43 +0000

hi,
I have an old database in mysql and now i want to transfer data of this to new database. The main issue i have is, there are some differences in structure of tables and fields.

Can anyone help me in migrating old database into new one ???

Regards,
Amit Chavda

Changing default values (1 reply)

Joseph Fisher — Fri, 06 Mar 2009 22:12:17 +0000

We originally installed a MySQL instance on two separate servers, using all of the default settings, to include datadir, socket, log-error, pid-file, etc.

We recently decided to cluster these servers, but the two database instances cannot co-exist on the same server at the same time, because they're both using the same port numbers, same log directories, etc.

I need to modify at least one of these configurations, so that it logs, and accesses the database instance via a different port.

Can anyone tell me which files need to be modified, and in which directories they exist?

I already created a copy of the mysqld startup script, and modified the entries in it.

Everything seems to startup just fine, as long as I don't change the socket location.

But, even though the mysqld command appears to work, and it can be seen using a ps -ef, I can not connect to the actual database.

I keep getting the following error message:

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

Check that mysqld is running and that the socket: '/var/lib/mysel/mysql.soc' exists!

Does anyone know how to modify the startup script, or configuration files, to move the database instance to the new port?

Thanks in advance, and have a great day.

Joe F.

import a csv file into multiple mysql tables (no replies)

cj p — Sat, 28 Feb 2009 07:34:13 +0000

Is there any way that I can import one .csv file using php and then distribute its contents into multiple tables?

Hi (no replies)

next age — Sat, 21 Feb 2009 01:00:01 +0000

How can I avoid error 1067?
It is repeated error, plz tell

Transfer data from one table to another in different DB connected under different user (no replies)

Jack jjj — Thu, 12 Feb 2009 07:25:46 +0000

Im using VB.Net and MySQl 5.0 . I have two database each having a lookuptable in it
I m login into each database as different user and both database resides in the same server. During a particular operation I need to get the data from 'lookuptable'
in the First DB to 'lookuptable' in the Second DB. Currently I was using looping in the VB.Net part but its taking long time to complete as the data is 2-3lakh. Could anybody please help how to resolve this issue using a "Insert into select query" in MySQl , but please remember The DB are different and the users to connect to db are also diferent.

Please help