MySQL Forums - Other Migration

Order Top Brands of Mobile Batteries, Cases and Covers Online. (no replies)

mobilephone accessories — Thu, 28 Mar 2013 12:27:35 +0000

Visit Day2day for all brands of mobile accessories, memory cards, iphone accessories, designer wall clocks models, gifts for sale, laptop accessories, electricals and electronics and more.

Migration from Oracle or SQL Server (3 replies)

Henderson Nigel — Thu, 28 Mar 2013 19:57:36 +0000

Hello Forum,

MySQL newbie posting a (possibly) dumb question.

I am looking to convert a database to MySQL.

I am in the fortunate (or unfortunate, I have no idea!) situation where the source database can either be SQL Server or Oracle, depending on what the customer wants. The question is, from a source standpoint, which one would be the best RDBMS to work from ?

The application that accesses the database is a client server system, written in c# (not sure if this is important) and connects via an ODBC driver.

Error trying to migrate from 3.23.51 to 5.1.66 (1 reply)

Gerald Livingston — Sat, 16 Feb 2013 04:56:24 +0000

NOTE: bbcode doesn't seem to be turned on here so the "code" blocks aren't clean.

Hello,

I'm trying to migrate from an OLD running 3.23.51 server to a new(er) 5.1.66 server. I've gone through the following steps:

On the old server:

mysqldump -p --add-drop-table --add-locks --all --quick --lock-tables radiator > radiator.sql

The .sql created is a bit over 2GB

Then I scp the .sql to the new server

On the new server:

iconv -f latin1 -t utf8 < radiator.sql > radiator-utf8.sql

sed -e "/auto_increment/ s/DEFAULT '0'//" radiator-utf8.sql > radiator-utf8-filt.sql

I then DROP the radiator database to ensure it doesn't exist and I run

mysql -p radiator
When I run it I get this error:

mysql  Ver 14.14 Distrib 5.1.66, for debian-linux-gnu (i486) using readline 6.1
root@radius1:~# mysql -p radiator 



-------------------------------------------------------





This is the first part of the .sql file





-------------------------------------------------------





-- MySQL dump 8.22
--
-- Host: localhost    Database: radiator
---------------------------------------------------------
-- Server version       3.23.51

--
-- Table structure for table 'ACCOUNTING'
--

DROP TABLE IF EXISTS ACCOUNTING;
CREATE TABLE ACCOUNTING (
  USERNAME char(50) NOT NULL default '',
  TIME_STAMP int(11) default NULL,
  ACCTSTATUSTYPE char(10) default NULL,
  ACCTDELAYTIME int(11) default NULL,
  ACCTINPUTOCTETS int(11) default NULL,
  ACCTOUTPUTOCTETS int(11) default NULL,
  ACCTSESSIONID char(30) default NULL,
  ACCTSESSIONTIME int(11) default NULL,
  ACCTTERMINATECAUSE int(11) default NULL,
  NASIDENTIFIER char(50) default NULL,
  NASPORT int(11) default NULL,
  FRAMEDIPADDRESS char(22) default NULL,
  KEY ACCOUNTING_I (USERNAME)
) TYPE=MyISAM;



Note that it seems to stop reading the first actual command line part way through. I don't understand what is happening at all.





Ideas?

CSV field exporting (no replies)

Gerardo Caudillo — Wed, 30 Jan 2013 17:02:16 +0000

Hello everyone,

I'm having lots of trouble with the following issue, im trying to export one field data into a new db table, what im trying to do is to delimit each field with commas but when i tried the following:

SELECT * INTO OUTFILE '/tmp/name.csv'
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\n'
FROM [tablename]

The field which is a log from a cisco router which gives the following output:

| 10.253.28.4 | local7 | info | info | be | 2013-01-15 | 10:58:12 | 144496 | Jan 15 17:11:06.509: %CALLTRKR-6-CALL_R ECORD: ct_hndl=71875, service=TcpClear, origin=Answer, category=Modem, DS0 slot/port/ds1/chan=3/1/1/7, called=7219, calling=55 55952194, resource slot/port=1/52, userid=c000317679330, ip=0.0.0.0, account id=239214, setup=01/15/2013 17:10:14, conn=0.01, phys=9.96, service=20.97, authen=20.89, init-rx/tx b-rate=2400/2400, rx/tx chars=203/153, charged units=0, time=30.36, disc su bsys=CSM, disc code=0x25, disc text=Modem Hang Up, sig type=Unknwn | 536918 |

keeps the fields delimitated by the pipes (|) so i get only 10 fields. I'm trying to get this output exported into an csv so i can re-import it into a new table with different fields. Thanks so much in front for your help.

Mysql4 to Mysql5 migration problem - SQL Syntax (no replies)

John Benobi — Sun, 06 Jan 2013 02:59:08 +0000

Hi,
I changed mysql4 to mysql5 and have a problem.
Propably this query from mysql4 (worked there fine) gives me syntax error in mysql5:

$q="select gs_hr.rin$hr as rin,gs_hr.uin$hr as uin,gs_hr.cl$hr as cl,gs_hr.out$hr as out,gs_hr.f$hr as f,gs_hr.a$hr as a,gs_hr.rin$hrl as rinhrl,gs_hr.out$hrl as outhrl,gs_hr.d as d,gs_tr.r as r,gs_tr.t as t,gs_tr.tr as tr,gs_tr.otr as otr,gs_tr.htr as htr,gs_tr.hotr as hotr,gs_tr.dowed as dowed,gs_tr.a as ca,gs_tr.drin as drin,gs_tr.dout as dout,gs_tr.etr as etr from gs_hr,gs_tr where gs_hr.d=gs_tr.d";

Echo shows me:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out,gs_hr.f4 as f,gs_hr.a4 as a,gs_hr.rin3 as rinhrl,gs_hr.out3 as outhrl,gs_hr.' at line 1
On site is got error: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ... 131

Lines 129-131:

129 | $q="select gs_hr.rin$hr as rin,gs_hr.uin$hr as uin,gs_hr.cl$hr as cl,gs_hr.out$hr as out,gs_hr.f$hr as f,gs_hr.a$hr as a,gs_hr.rin$hrl as rinhrl,gs_hr.out$hrl as outhrl,gs_hr.d as d,gs_tr.r as r,gs_tr.t as t,gs_tr.tr as tr,gs_tr.otr as otr,gs_tr.htr as htr,gs_tr.hotr as hotr,gs_tr.dowed as dowed,gs_tr.a as ca,gs_tr.drin as drin,gs_tr.dout as dout,gs_tr.etr as etr from gs_hr,gs_tr where gs_hr.d=gs_tr.d";
130 | $r=mysql_query($q);
131 | while($row=mysql_fetch_array($r)){$d=$row["d"];

Please help

I need this query working on mysql5.
Could you please help me convert it ?

Benobi

Microsoft SQL Server Management Studio query to MySQLWorkbench (no replies)

Leon Sharkoon — Wed, 19 Dec 2012 20:04:25 +0000

Hi

Just trying to create some new tables. I've tested them already in office, and want them now in MySQLWorkbench too.
That's the query, which I exported from MS SQL Studio:

USE [SAM_PLAYGROUND_LOCAL]
GO

/****** Object: Table [dbo].[RSS_FEEDS] Script Date: 12/19/2012 17:26:14 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[RSS_FEEDS](
[RSSID] [int] IDENTITY(1,1) NOT NULL,
[Provider] [varchar](50) NULL,
[FeedName] [varchar](100) NULL,
[varchar](1000) NULL, [Language] [varchar](2) NULL, [dt_insert] [datetime] NOT NULL, [dt_remove] [datetime] NULL, [Frequency] [int] NULL, [dt_lastUpdate] [datetime] NULL, CONSTRAINT [PK_RSS FEEDS] PRIMARY KEY CLUSTERED ( [RSSID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[RSS_FEEDS] ADD CONSTRAINT [DF_RSS FEEDS_dt_insert] DEFAULT (getdate()) FOR [dt_insert] GO //-------------------------// Thats the error I get: Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '[SAM_PLAYGROUND_LOCAL] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SE' at line 1 //-------------------------// What's wrong with my query? Sorry for the bad format, but I don't know how to handle it right :D Thank you all! //-------------------------// Regards Leon

moving database from (win 32bit) MySql 4.0.20a to (redhat 64bit) MySql 5.1.61 (no replies)

Florin P — Wed, 14 Nov 2012 15:19:33 +0000

I have received a very old system running MySql 4.0.20a on a Windows Server 2003 Standard 32bit.

mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.20a, for Win95/Win98 (i32)

Connection id: 19
Current database:
Current user: root@localhost
SSL: Not in use
Server version: 4.0.20a-debug
Protocol version: 10
Connection: localhost via TCP/IP
Client characterset: latin1
Server characterset: latin1
TCP port: 3306

I would like to be able to transfer/move the database to a CentOS 6.3 64it server, running MySql 5.1.61;

mysql> status
--------------
mysql Ver 14.14 Distrib 5.1.61, for redhat-linux-gnu (x86_64) using readline 5.1

Connection id: 3
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: stdout
Using outfile: ''
Using delimiter: ;
Server version: 5.1.61 Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: latin1
Db characterset: latin1
Client characterset: latin1
Conn. characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock

The engine used is MyISAM.

Are there any howtos anyone can point me to?

Someone was mentioning about "changing the decimal definitions in databases structure dump". Do I need to do it? How is it done?

Show I update to the latest GA version on MySql [ Red Hat/Oracle Enterprise Linux ver. 6 (x86, 64-bit), RPM Package MySQL Server 5.5.28 (MySQL-server-5.5.28-1.el6.x86_64.rpm) ] before attempting to do the transfer/move?

This is my first encounter with the MySql stuff (or any sql server) and I would appreciate all the advice I would get!

Thanks.

MySQL Database Sync (no replies)

Mohan Kodali — Wed, 07 Nov 2012 09:05:47 +0000

We have developed a web application with MySQL as the back end. This application will be deployed in places where there will not be internet access. In that case, I think I have two options, I will write a batch process that will dump all the data in to a flat file and then upload the data later in to the online database. I dont know if I have any better options. It would be great if you can suggest me some options. My application is developed in PHP/MySQL.

Thanks,
Mohan

I can't access the MYSQL after setting the root password (1 reply)

Eliza Makens — Wed, 31 Oct 2012 08:56:01 +0000

Hi,

I am new to web development. I am xampp package for development. First I was able to access MYSQL through CLI and PhpMyAdmin. But when I set the root password for the MYSQL, I am unable to access it.

Any clue?
Thanks

Migrate a Database from HSQLDB to SqlServer (no replies)

V User — Tue, 23 Oct 2012 10:12:39 +0000

Is there a list of steps anywhere to migrate a database from hsqldb to MySQL. I am running MySQL 5.5 on Windows.

[DONE] Fail to Login after Migration (no replies)

Fabian Zünd — Thu, 18 Oct 2012 13:46:07 +0000

Hello.

We're currently Migrating a few MYSQL Databases form an Old MYSQL-Server (4.1.15) to a new MYSQL-Server (5.5.23).

It worked first. I could Import everything, even the Users.

But after the Restart it failed to start with the old known "mysql.user table is not updated to new password Format"

So i did the mysql_upgrade Command.

It fixed everything. Server start without any Errors but when i try to Login with root again, it Fails.

Error 1045 Acess denied for user 'root'@localhost:
I tought maybe the Password of the Old Server was different. I used Pants off to Find it out (GUI Login MasK). I copied & pasted it and altough that didn't work either. Error 1045.

I put in the Orginal Files from the MYSQL Database in again restart it and it works again.

So why does the old MYSQL Database with the Same Password as the new one not work after using the Upgrade Command?

//edit: I realized something. I can delete the whole MYSQL-Database after the Upgrade. That shouldn't be possible when it is in use?

//edit:

Well i came a bit Further.

I can now Login after MYSQL_UPGRADE. I did the following Thing:

Imported old Database.

Got into the Database mysql in the user Table.

Set the Length of Password from CHAR(16) to CHAR(41)

And then Updated the Root Password.

update mysql.user set password=PASSWORD('XXXXX') where user='root';

Then upgraded the Database.

Now i'm able to Login again and the Old Users are all Visible.

So after 6-7h i Finally got it.

So this is finished for the Moment.

LOG:

121018 15:05:50 [Note] Plugin 'FEDERATED' is disabled.
121018 15:05:50 InnoDB: The InnoDB memory heap is disabled
121018 15:05:50 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121018 15:05:50 InnoDB: Compressed tables use zlib 1.2.3
121018 15:05:50 InnoDB: Initializing buffer pool, size = 1013.0M
121018 15:05:52 InnoDB: Completed initialization of buffer pool
121018 15:05:52 InnoDB: highest supported file format is Barracuda.
121018 15:05:53 InnoDB: Waiting for the background threads to start
121018 15:05:54 InnoDB: 1.1.8 started; log sequence number 16248280
121018 15:05:54 [ERROR] Column count of mysql.db is wrong. Expected 22, found 15. The table is probably corrupted
121018 15:05:54 [ERROR] mysql.user has no `Event_priv` column at position 29
121018 15:05:54 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
121018 15:05:54 [Note] C:\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.23' socket: '' port: 3306 MySQL Community Server (GPL)
121018 15:08:28 [Note] C:\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown

121018 15:08:28 InnoDB: Starting shutdown...
121018 15:08:28 InnoDB: Shutdown completed; log sequence number 16248280
121018 15:08:28 [Note] C:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

After Upgrade Command:

121018 15:09:31 [Note] Plugin 'FEDERATED' is disabled.
121018 15:09:31 InnoDB: The InnoDB memory heap is disabled
121018 15:09:31 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121018 15:09:31 InnoDB: Compressed tables use zlib 1.2.3
121018 15:09:32 InnoDB: Initializing buffer pool, size = 1013.0M
121018 15:09:34 InnoDB: Completed initialization of buffer pool
121018 15:09:34 InnoDB: highest supported file format is Barracuda.
121018 15:09:36 InnoDB: Waiting for the background threads to start
121018 15:09:37 InnoDB: 1.1.8 started; log sequence number 16248280
121018 15:09:37 [Note] Event Scheduler: Loaded 0 events
121018 15:09:37 [Note] C:\MySQL\MySQL Server 5.5\bin\mysqld: ready for connections.
Version: '5.5.23' socket: '' port: 3306 MySQL Community Server (GPL)
121018 15:22:10 [Note] C:\MySQL\MySQL Server 5.5\bin\mysqld: Normal shutdown

121018 15:22:10 [Note] Event Scheduler: Purging the queue. 0 events
121018 15:22:10 InnoDB: Starting shutdown...
121018 15:22:11 InnoDB: Shutdown completed; log sequence number 16248290
121018 15:22:11 [Note] C:\MySQL\MySQL Server 5.5\bin\mysqld: Shutdown complete

H2 to mySQL (no replies)

Tariq Mehmood — Wed, 15 Aug 2012 15:41:26 +0000

Hi all,

I recently did a data transfer from H2 to mySql.
I copied all the tables from H2 using a bash script
Converted them into .csc files(each table has a .csv file)
Ran mysqlimport command to dump these .csv files into MySQL database(data transfer to MySQL was successful, it is skipping some records in some of the tables, which i believe because of relationships)
Gerrit is starting OK
First user was created in MySQL table and given administrative rights.
I cannot see all the repos in Gerrit.
Error log is as follows:Thanks for the reply,
the error log looks like this in my case:

[2012-08-15 11:46:33,637] WARN / : Error in allQueryNext
java.lang.IllegalStateException: Missing project All-Projects
at com.google.gerrit.server.project.ProjectCacheImpl.getAllProjects(ProjectCacheImpl.java:90)
at com.google.gerrit.server.account.CapabilityControl.(CapabilityControl.java:55)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.google.inject.internal.DefaultConstructionProxyFactory$2.newInstance(DefaultConstructionProxyFactory.java:85)
at com.google.inject.internal.ConstructorInjector.construct(ConstructorInjector.java:85)
at com.google.inject.internal.ConstructorBindingImpl$Factory.get(ConstructorBindingImpl.java:254)
at com.google.inject.internal.InjectorImpl$4$1.call(InjectorImpl.java:978)
at com.google.inject.internal.InjectorImpl.callInContext(InjectorImpl.java:1024)
at com.google.inject.internal.InjectorImpl$4.get(InjectorImpl.java:974)
at com.google.inject.assistedinject.FactoryProvider2.invoke(FactoryProvider2.java:632)
at $Proxy35.create(Unknown Source)

Any thoughts/pointer are welcome and Thanks in advance for your help.

Althought iam getting Application error in the browser but it is authenticating the user which was created when i hit continue.

Tariq

Migrating from H2 to mySQL (no replies)

Tariq Mehmood — Wed, 15 Aug 2012 13:36:11 +0000

Copy Tables from H2 to mySQL (no replies)

Tariq Mehmood — Thu, 26 Jul 2012 16:34:20 +0000

Hi All,
I am trying to copy database tables from H2 to mySql in RedHat. I have no experience with H2 and some experience with mySql.
I have already created empty database tables in mySql exactly same as they exist in H2.
Now the challenge is to copy all the data from tables in H2 database to mySql in a less painful way.
Would you be kind enough to point me to the right direction that how should i approach this.
Any help is appriciated.
And Thanks in advance for your help.

Best Regards,
Tariq

upgrade from 4.1 to 5.5 (1 reply)

sam engr — Tue, 13 Nov 2012 21:33:27 +0000

I have read so many articles stating upgrade 4.1 to 5.0 then 5.0 to 5.1 and then 5.1 to 5.5.

My existing setup:

OS: RHEL5.8
MySQL: 4.1.22
ENGINE=MYISAM

will the following upgrade method work fine? if not why?

1. Get one to two weeks query log on old mysql (4.1.22).
2. Dump databases structure only (--no-data ) of existing MySQL 4.1.22
3. Dump databases (--with-data ) of existing MySQL 4.1.22
4. Install mysql-5.5 on other machine
named mysqltest1
5. Change the decimal definitions in databases structure dump (taken at step 2) as it was a major issue pointed out in almost all forums.
6. Verifies the timestamp definitions in databases structure dump (taken at step 2).
7. Restored the database structre got from step 2, 5 and 7
8. Restore the databases without dropping & creating databases & tables.
9. Run mysql-upgrade on mysql-5.5 to get and fix the table incompatibilities.
10. Disable concurrent inserts by setting concurrent_insert=0 in my.cnf on mysqltest1
11. Install mysql-4.1.22 on another machine named mysqltest2
12. Restore dumps taken on step 3 on this mysqltest2.
13. Play query log I got on step 1 on both machines (mysqltest1 and mysqltest2) with mk-upgrade
------(mk-upgrade compares query execution on two hosts by executing queries in the given file (or STDIN if no file given) and examining the results, errors, warnings, etc.produced on each.)
14. Rewrite the queries in code (especially Join if required by step 13's output)
15. Run the new queries on mysqltest1 and log the queries by enabling query-logs(general).
16. If satisfied on step 15 then push this machine mysqltest1 a slave machine with existing mysql-4.1.22 master.
17. Enable query logs on the new slave machine mysqltest1
18. Monitor for a week and address if we get any errors
19. If all ok in step 18 then upgrade all of your slave machines to mysql5.5 ; upgrade half of the slave machines to mysql 5.5 if you can maintain one tree for mysql-4.1.22 and one tree for mysql-5.5
20. Monitor for a week or two and then upgrade your secondary master to mysql-5.5 and then note issues if you get any in log.
21. Promote this secondary master to primary master by redirecting app/web traffic to this mysql-5.5 box.
22. Monitor for a month or so and then if all ok then upgrade rest of slave to mysql-5.5 and then the old primary master and then sync the data with replication on these latest upgraded machines.
23. All done.

I would like to see some comments.

Cheers

unable to restore (no replies)

sam engr — Tue, 26 Jun 2012 10:48:22 +0000

Getting error when I try to import my database backup (no replies)

Brandee Fleury — Sat, 26 May 2012 16:02:15 +0000

I get this error:

SQL query:

--Backup of `wp_commentmeta` ends -- Backup of `wp_comments` -- Structure of `wp_comments` CREATE TABLE `wp_comments` ( `comment_ID` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `comment_post_ID` bigint(20) unsigned NOT NULL DEFAULT '0', `comment_author` tinytext NOT NULL, `comment_author_email` varchar(100) NOT NULL DEFAULT '', `comment_author_url` varchar(200) NOT NULL DEFAULT '', `comment_author_IP` varchar(100) NOT NULL DEFAULT '', `comment_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_date_gmt` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `comment_content` text NOT NULL, `comment_karma` int(11) NOT NULL DEFAULT '0', `comment_approved` varchar(20) NOT NULL DEFAULT '1', `comment_agent` varchar(255) NOT NULL DEFAULT '', `comment_type` varchar(20) NOT NULL DEFAULT '', `comment_parent` bigint(20) unsigned NOT NULL DEFAULT '0', `user_id` bigint(20) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`comment_ID`), KEY `comment_approved`[...]

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--Backup of `wp_commentmeta` ends

-- Backup of `wp_comments`

-- Structure of `' at line 1

I have no idea how to fix this and if this is even posted in the right place. I would appreciate it SO MUCH if someone could help me. This is my WordPress database backup!

cannot import database (1 reply)

Wendy Kaisara — Sun, 03 Jun 2012 11:02:09 +0000

Hi,
I am using wampserver 2.2 and am trying to import script to create table customers:
CREATE TABLE IF NOT EXISTS `customer` (
`customerID` int(12) NOT NULL auto_increment,
`customerName` varchar(20) NOT NULL,
`address` varchar2(30) NOT NULL,
PRIMARY KEY (`customerID`)
) ENGINE=InnoDB;

But im getting this error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'varchar2(30) NOT NULL,
PRIMARY KEY (`customerID`)
) ENGINE=InnoDB' at line 14

Please help.

Illegal mix of collations after migrating (no replies)

Cain Nuke — Sat, 19 May 2012 06:16:09 +0000

Hi,

im migrating from a windows server to a linux server. On the windows server i have no problem but on linux im getting this error:

Error: 1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='

i really dont know why it happens because the same database works just fine on Windows so i wonder whether its an import error or a problem in the linux server configuration. Could you please help me?

Thank you.

Errcode: 2 Problem in using Infile (2 replies)

Safi Siddiqui — Thu, 12 Jul 2012 19:01:00 +0000

Sorry. My Mistake, put the question in wrong place in the forums. How do I delete the question? =/

_________________________________

Hello,

I'm having an issue with loading data into a table using load script.

This is my script:

LOAD DATA INFILE 'C:\Users\m\Desktop\a2\DCES.dat'
into table test_table
FIELDS TERMINATED BY ';'
LINES TERMINATED BY '\n'
IGNORE 3 LINES
(DCES_Id,Consumer_name,Consumer_Address,Billing_Month,DCES_Present_Reading,DCES_Previous_Reading,DCES_Unit_Consumption,DCES_Energy_Charges,DCES_Surcharges,DCES_Total,DCES_Late_payment,DCES_Due_date);

Every time I run this script it gives the error: "#29 - File 'C:\xampp\mysql\data\UsersmDesktopa22DCES.dat' not found (Errcode: 2)"

I tried adding 'LOCAL' to the script, but it just gave me a new error. "#7890 - Can't find file 'C:UsersmDesktopa22DCES.dat'."

Also, the path I have given is correct, I have checked, and rechecked it. The file is absolutely present at this location, but it is not being found.

Any help would be greatly appreciated.

Import CSV and other formats with table structure (no replies)

c n — Tue, 24 Apr 2012 08:43:49 +0000

Hi,

sorry about the double post. I noticed that the subject did not describe the problem.

How can tables from CSV- and other textfiles be imported into mysql in a way that the corresponding table is created in the process ?

The data itself can be imported with "load data..." but that does not create nor check the structure of the tables. "Load data" only works if the table already exists and already has the correct structure.

Here we have project-related tables in textfiles that are generated by different software and change their structure frequently so keeping the mysql-table-structures up to date is quite a drag. So I am hoping that there is some mysql-command or tool that will help out.

THX,stn

Import CSV and other formats (no replies)

c n — Mon, 23 Apr 2012 13:12:55 +0000

Hi,

How can tables from CSV- and other textfiles be imported into mysql?

The data can be imported with "load data..." but that does not create nor check the structure of the tables. "Load data" only works if the table already exists and already has the correct structure.

Here we have project-related tables in textfiles that are generated by different software and change their structure frequently so keeping the mysql-table-structures up to date is quite a drag. So I am hoping that there is some mysql-command or tool that will help out.

THX,stn

How to Migrate MySQL from one server to other (1 reply)

Willi Lohan — Wed, 25 Apr 2012 06:47:28 +0000

Hi, I want to Know how to transfer mysql data from one server to another,
I have been working with a Dating Site loverseath.com as database is becoming bigger i want to change the server i tried importing it to my local hard disc but the some data were missing, i want to know a permanent solution

Migrating MySQL 5.0 to MySQL 5.5 (no replies)

Khuram Raza — Tue, 20 Mar 2012 18:27:53 +0000

Greetings All,

can anyone guide me on how to migrate MySQL 5.0 to a new server running MySQL 5.5??

my server is running more than 95 databases, i need to migrate users along with it as they are also 200+ in number.

if i want to use MySQLDump, i can use this command

mysqldump -u root -pPassword -x --all-databases > db_dullll.sql
mysql -u root -pPassword < db_dullll.sql

but this is not working as databases get transfer users don't.

thanks in advance :)

Cannot access mysql after update (1 reply)

Elias Papas — Fri, 09 Mar 2012 21:21:28 +0000

Hi!
I am trying to update mysql from 4.1.14 to 5. When it finishes I am unable to connect to mysql. So I don't know what to do next.
I do the update process from my hoster's control panel. My hoster is yahoo and I use the following menu;
< Upgrade to MySQL 5 now.>>
I click on "upgrade to mysql now", wait till it finish and then I get a "succesfull upgrade" message. But I cannot access my db. (Could not connect to mysql).
Yahoo doesn't help me as I wanted to , so please give me an advice of what should I do...
Please help me!

Migrating MySQL database (no replies)

Chris Kimberley — Thu, 23 Feb 2012 17:30:42 +0000

Hi all,

I've been doing a lot of reading lately on ways to migrate MySQL. The traditional way I've migrated a database is by using the mysqldump tool, but I'd like to explore some other options.

In my test environment I have two mysql servers live and running on two different machines (all linux based). I am using many InnoDB tables. Before I perform a method of grabbing the contents in the MySQL data directory I will be issuing a flush table with read lock command.

Because i'm using InnoDB, RSync is not an option because reads can still place while the RSync is happening. From what I've read this can cause issues with the table space and log files as they may copy over in a corrupted state even if all writes have been locked by the flush tables.

I'm wonding if using tar and gunzip will have similar issues as an RSync with InnoDB. The zip will lock a tablespace file or log file while it's performing the compression, but the other related files to InnoDB will still be able to perform reads. If a disk flush happen can this lead to issues ? Or does gunzip/tar lock all the files at once ? Does any of this even matter when the files get copied over to the other server and MySQL is started ? Does MySQL sort everything out when it starts ?

I'm particularly interested in any answers to the tar/gunzip method. Any other suggestions for migrating the DB are welcome.

Thanks,
Chris

EndNote (1 reply)

Colleen Boye — Fri, 17 Feb 2012 16:31:30 +0000

Has anyone ever interfaced EndNote with MySQL? How doable is it?

AIX 5.3 Filesize Problems (no replies)

Tom Melly — Mon, 13 Feb 2012 04:17:22 +0000

Hi,

Hope this is the right forum for this...

I'm trying to restore a large db onto an AIX 5.3 server (mysqldump from WinXP).

This is failing during the restore due to an O/S file size issue on the target server.

One option is to break the dumped database into smaller chunks, and restore each chunk one at a time. However, this won't really help me if I still run into file size issues for the target DB (the current file size issue LOOKS like it relates to temporary files).

So, my question is - does mysql adapt to file-size limits? i.e. will it break table-files down into acceptable sizes or will it hit this issue irrespective of how I handle the restore?

I should add that at this point I am unsure whether the file-size limit is due to user-set limits or O/S physical limits (AIX 5.3 iirc has to have large file size support configured when the file-system is created).

Many thanks for any advice or observations anyone can offer...

dedicated to virtual platform (no replies)

albrius kasinskas — Wed, 01 Feb 2012 14:09:33 +0000

Hi,

I was wondering if any1 had faced the challenge of migrating MySQL database from dedicated single server to a virtual platform with multiple virtual servers ?
Any tips ? tricks ? references ? or suggestions ?

All would be much appreciated.

I need to migrate from 4.0 to 5.5! Easy..er Way? (1 reply)

Chris Stratis — Fri, 27 Jan 2012 18:26:21 +0000

Hi,
I need to migrate from MySQL 4.0 to My SQL 5.5. My first thought was hopscotching from 4.0 to 4.1 to 5.0 to 5.5..... I decided to make that my last resort because I have an immense amount of data that has to be migrated. That process would probably take a week. Does anyone else have any ideas? Did anyone write something that will semi-automate the process?

Thanks,
--Chris