On Thu, Dec 9, 2010 at 9:10 AM, Shawn Green (MySQL)
wrote:
> On 12/8/2010 22:50, Robert Citek wrote:
>>
>> Greetings to all,
>>
>> Can I migrate slave databases between slave servers?
>>
>> Imagine the following scenario: I have one master database server with
>> 10 databases. I also have two sla
On 12/8/2010 22:50, Robert Citek wrote:
Greetings to all,
Can I migrate slave databases between slave servers?
Imagine the following scenario: I have one master database server with
10 databases. I also have two slave database servers, one replicating
5 of the 10 databases, the other replicati
> 2. Don't stare at the screen. Start it, script the process & have it email
> your phone when it's done. Do something else in the mean time.
I don't literally stare at the screen -- of course I script it and do
other things.. but when I have a resource limited environment, it sure
would be ni
In the last episode (Sep 28), Gavin Towey said:
> Also note, 5.5 isn't production ready. 5.1 is the current GA release.
5.5 is really really close, though (5.5.6 is marked as Release Candidate),
Better to switch now while you're already doing a migration, and then
install 5.5.x updates as they ha
Also note, 5.5 isn't production ready. 5.1 is the current GA release.
-Original Message-
From: Hank [mailto:hes...@gmail.com]
Sent: Tuesday, September 28, 2010 3:29 PM
To: mysql@lists.mysql.com
Subject: Migrating my mindset from MyISAM to InnoDB
Primarily due to many positive posts I've
1. Generally reducing fragmentation in the data/index files will reduce the
footprint of tables on disk, and can be more efficient to query. With innodb
you need to be using the innodb-file-per-table option, and then you can use
OPTIMIZE TABLE table; to rebuild it. You don't get detailed progr
In the last episode (Feb 22), Ed Curtis said:
> I'm doing the above migration as mentioned in the subject line. I figured I
> would use the MySQL Migration Toolkit to help it along but it won't let me
> connect to my 3.23.49 server. Is there any other way to migrate all my data
> easily.
Basica
On Fri, February 22, 2008 10:01, Ed Curtis wrote:
> I'm doing the above migration as mentioned in the subject line. I
> figured I would use the MySQL Migration Toolkit to help it along but it
> won't let me connect to my 3.23.49 server. Is there any other way to
> migrate all my data easily.
>
> Th
Here's what we did and still do :
Our 4.x tables and databases were/are in Latin-1 and all the 5.x tables
are/were in utf8. That means that the entire regiment of items (every column,
every table, every database) in the old system (4.1) was latin-1 and all the
destination items in 5.x were ent
>> > i've still serious trouble in migrating databases createted with 4.0 to
>> 5.0.
>> > the problems is still the charset. i'm connecting to mysql with php and
>> when
>> > i try to use the 5.0 db german special chars are messed up. afaik 4.0
> > uses latin charset and 5.0 utf8 by default. can s
Am Montag, 5. März 2007 14:35 schrieb Martijn Tonies:
> Hi,
>
> > i've still serious trouble in migrating databases createted with 4.0 to
> 5.0.
> > the problems is still the charset. i'm connecting to mysql with php and
> when
> > i try to use the 5.0 db german special chars are messed up. afaik 4
Hi,
> i've still serious trouble in migrating databases createted with 4.0 to
5.0.
> the problems is still the charset. i'm connecting to mysql with php and
when
> i try to use the 5.0 db german special chars are messed up. afaik 4.0 uses
> latin charset and 5.0 utf8 by default. can some one pleas
On Mon, Mar 05, 2007 at 08:30:13AM +0100, Matthias Henze wrote:
> hi,
>
> i've still serious trouble in migrating databases createted with 4.0 to 5.0.
> the problems is still the charset. i'm connecting to mysql with php and when
> i try to use the 5.0 db german special chars are messed up. afai
Hi Sean,
I used to have similar problems with different character sets and my
solution is:
1) dump all data using mysql dump utility
2) check if data are OK - view your data with viewer which suports correct
character set
3) if data are not OK try to dump data in different character set
4) you
Hi,
I have figured out a way to get this to work. I am just posting what
I did in case anyone else stumbles across my original message. I am
sure there are other ways to get this to work, but this is the way
that worked for me:
###
# My HOW
On Mon, Sep 05, 2005 at 11:00:43AM -0700, Karam Chand wrote:
> First all it is not recommended at all to dump and
> import user information.
Why not? They are just entries in a database, like any other. How
would you propose I move a large batch of users to another database
server?
> Secondly
On Mon, Sep 05, 2005 at 12:41:50PM +0300, Gleb Paharenko wrote:
> Hello.
>
> Have you run 'FLUSH PRIVILEGES'?
Doh! I got everything else find, but forgot something stupid.
Murphy's law, I suppose.
Thanks for the prompt!
Ross
--
MySQL General Mailing List
For list archives: http://lists.mysql
Hello,
First all it is not recommended at all to dump and
import user information.
Secondly the user authentication system has changed
between 4.0 and 4.1 so old passwords from 4.0 wont
work. Its given in the docs.
Thirdly, MySQL does not store the actual password in
its database. It always kee
Hello.
Have you run 'FLUSH PRIVILEGES'?
[EMAIL PROTECTED] wrote:
> On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote:
>> Now I have all the users in the new mysql.user table. But when I try
>> to login, the same credentials do not work.
>
> A bit more info on this. T
On Sun, Sep 04, 2005 at 10:08:32PM -0400, [EMAIL PROTECTED] wrote:
> Now I have all the users in the new mysql.user table. But when I try
> to login, the same credentials do not work.
A bit more info on this. This interesting error happens with GRANT:
mysql> grant all on testing.* to testing@'%'
Wiebe de Jong <[EMAIL PROTECTED]> wrote on 02/09/2005 17:32:07:
> I used mixed case in naming my schemas, tables and fields in Postgres
7.1.
> (i.e. onDemand.callDetailRecord) Now I have to move my app over to
MySQL.
>
>
>
> What are the best practices for naming in MySQL?
Definitely use low
Hi Rahul,
There are ODBC drivers that you could use, also you may like to look the
BCI and/or UCI interfaces. If you can flatten the data (eg. no
multivalues) you could put the lot into a Type 1 or Type 19 file and
then load the data as required.
You could also just create an I descriptor to get
Hello,
I guess IBMs Universe Database will be having an ODBC
interface. Then you can use a GUI like SQLyog
(www.webyog.com) to do an ODBC Import from IBMs
database to MySQL.
Regards,
Karam
--- Rahul Bollampally <[EMAIL PROTECTED]> wrote:
> Hi,
>
> Has any body migrated an IBM's Universe databa
MySQL data files are binary compatible from one machine to another.
Even InnoDB
data files. As long as you are not trying to "upgrade" from version 3.23 to
version 4.1, you are okay with copying the data files from one machine to
another.
--
Partha Dutta
Sr. Consultant, MySQL Inc.
Quoting Chris
Brian Erickson wrote:
>Greetings all,
>
>We are migrating our web site from one server to another and are
>having some issues with transferring our MySQL database. Here's the
>process we're currently using:
>
>1) run mysqldump for each table in our database (i.e. one file for each table)
>2) compr
Temporary replication comes to mind fs hot copy as well (maybe)
--
Chris.
I love deadlines. I especially love the whooshing sound they make as they
fly by..." - Douglas Adams, 'Hitchhiker's Guide to the Galaxy'
- Original Message -
From: "Brian Erickson" <[EMAIL PROTECTED]>
To:
o the inserts without the
create table information. I don't think you will 've any problem if you just
added new columns.
Good luck,
MARTIN
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: martes, 05 de octubre de 2004 17:03
To: [EMAIL PROTECTED]; [EMAIL
Kevin Cowley
R&D
Tel: 0118 902 9099 (direct line)
Email: [EMAIL PROTECTED]
Web: http://www.alchemetrics.co.uk
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]
> Sent: 05 October 2004 16:03
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>
Hi,
I am also doing migration from oracle 7.3 to mysql 4.0 classic.
May i know how to handle Oracle Views, stored procedures/triggers in MySQL 4.0 ?.
May i know how to create database, table space, roll back segments, users, allocating
tables to table spaces (as we do in oracle) in m
Show warnings is not available until 4.1.x
...
The empty field will be imported as that. Empty and not a null value.
...
Have you tried importing the data yet to see how the date fields look in
MySQL?
-Original Message-
From: Robert L Cochran
To: [EMAIL PROTECTED]
Sent: 6/28/04 9:20 PM
Sub
Why don't you use the export utility in ms access to load the data into
mysql. The export will create the table in the database. All you need is
a dsn connection and the mysql odbc.
Osvaldo Sommer
-Original Message-
From: Robert L Cochran [mailto:[EMAIL PROTECTED]
Sent: Monday, June 28,
Bob
My versions are Access 2000 and MySQL 4.0.20. Here's what I do.
When exporting my Access table, I choose the file type Text Files.
Then, on the next dialog box, make sure to click the Advanced button to
get to the formatting information. Change the date order to YMD and the
date delimiter to
Hi,
> 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
Try SQLyog - www.webyog.com
I use the ODBC Import Facility regularly.
regards
Karam
--- Arjun Subramanian <[EMAIL PROTECTED]> wrote:
> 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
Arjun Subramanian wrote:
Do you have any
specific sites or utilities in mind ?
Try the code posted in this newsgroup posting:
http://groups.google.com/groups?q=macro+access+export+mysql&hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=tchs8rl5phqib7%40corp.supernews.com&rnum=3
It's a little long to post here
d. 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
>
Try using the actual MySQL dump command
mysqldump --B --tables -u --opt -p -h |
mysql -u -p -h
>> Original Message <<
On 2/5/04, 10:46:21 AM, UpFront Technology <[EMAIL PROTECTED]>
wrote regarding migrating mysql database:
> Hello,
> I am trying to copy
Timothy Stone <[EMAIL PROTECTED]> wrote:
> Okay, don't cut my head off. MySQL is new for me, but I'm not new to
> databases.
>
> I have a MySQL DB for development running on WinNT (3.23.51-max-nt). I'm
> migrating the database for development to Mac OS X MySQL 4.0.12.
>
> I've read both the "Upgr
Hi Edward,
Use DBTools Manager 2.0.1 (http://www.dbtools.com.br). It imports
structure, data, indexes, queries and relationships from MSAccess and it's
totally free.
[]s
Crercio
- Original Message -
From: "Edward Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, February 1
there is a tool called SQLyog at http://www.webyog.com/sqlyog/download.html
It has a very good ODBC import tool which will import your Access data to
MySQL without any fuss and its FREE!!!
Insane
- Original Message -
From: "Edward Kim" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wed
Try the script oracledump.pl at this link. I used it to export my
Oracle data to Mysql and it worked great. Some variables to modify at
the top of the script, but that's it.
http://mirrors.sunsite.dk/mysql/Downloads/Contrib/oracledump
Stanley G. Martin
Sprint - ISS Enterprise App/Decision Supp
> From: Francois Joubert [mailto:[EMAIL PROTECTED]]
> Sent: 16 August 2002 14:46
> To: MySQL List
> Subject: Migrating Oracle To MySQL
>
> Hi
>
> I am new to the world of databases. We will be installing an Oracle9i
> database shortly as the backend for our current financial package. We
> hope t
Thanks for the response! I'm comfortable with it but I wanted a second
opinion.
-Josh
Galen Wright-Watson wrote:
> On Wed, 12 Jun 2002, Joshua Horton wrote:
>
> > Hi,
> >
>
> > First, I'm having trouble determining whether or not it is possible
> > to drop a user, or whether I have to go
Thanks! I used the file transfer; I don't think the grants/revokes
completely transferred, but that's easy enough to fix. :)
Benjamen R. Meyer
> Hi.
>
> I had the same problem awhile back.
>
> What i did was just copy the db files to the linux server
> provided the mysql versions are exactly the
Hi.
I had the same problem awhile back.
What i did was just copy the db files to the linux server
provided the mysql versions are exactly the same and
the db structures are the same it works.
Otherwise mysqldump and read it into the new db:)
//Uffe
Witness wrote:
>
> Hello. I am running a My
Very
There are tools to migrate from or to
oracle,XL,Access
Simon
-Original Message-
From: Radhakrishnan Sundaresan [mailto:[EMAIL PROTECTED]]
Sent: 24 September 2001 15:52
To: [EMAIL PROTECTED]
Subject: Migrating to other databases
Hi
I was won
try mssql2mysql; this is a VB/VBA script which can connect directly to
MySQL, thus eliminating the need of temporary files
http://www.kofler.cc/mysql/mssql2mysql.html
Best wishes,
Michael Kofler
-
Before posting, please c
mailto:[EMAIL PROTECTED]]
> Verzonden: donderdag 9 augustus 2001 7:45
> Aan: Bart Goormans
> Onderwerp: Re: Migrating from MS SQLserver to MySQL
>
>
> I had an almost similar problem with conversion from
> Access to MySQL and that was easily solved by
> generating an SQL
I'll look into this,
Thanks,
bart goormans
(will be following up on this thread shortly ...)
Van: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Verzonden: donderdag 9 augustus 2001 3:53
Bart:
There are many ways to skin this cat, but this is one we have used
recently
with good success.
Cr
'DTS' the information ?
Sorry Edgart, what exactly do you mean by that ?
bart
From: Edgart Gonzalez [mailto:[EMAIL PROTECTED]]
augustus 9, 2001 3:39
You can DTS you information from MsSql to MySQL via ODBC.
-Original Message-
From: Bart Goormans [mailto:[EMAIL PROTECTED]]
Sent: Wedn
Bart:
There are many ways to skin this cat, but this is one we have used recently
with good success.
Create a script in MSSQL7 (you can do it through the Enterprise Manager) so
can re-create the database schema in MySQL. There are some syntax
differences between MSSQL7 and MySQL, but it is prett
Date |Tue, 07 Aug 2001 13:24:02 +0200
>From |Frank Fisher <[EMAIL PROTECTED]>
Hello!
FF> My company just stole my web server running MySQL. I will now have to
FF> host my site on a consolidated server that has MS SQL Server.
FF> How do I migrate? I think my SQL code will be good except for
52 matches
Mail list logo
