Hello,
I have a background process that runs as a combination of PHPMySQL. The
end results are records in a table on server #1 (but not the entire table,
just a small subset of the table needs to move). What's the
easiest/cleanest way of moving those records to an identical table on
another
On 1/4/2011 15:53, Hank wrote:
Hello,
I have a background process that runs as a combination of PHPMySQL. The
end results are records in a table on server #1 (but not the entire table,
just a small subset of the table needs to move). What's the
easiest/cleanest way of moving those records
Wow, that might just work! I've seen Federated tables mentioned about,
but I never knew that's what they are here for.. thanks.
Can I have a host (remote) table on a MySQL 4.1.x server, and the federated
table on a 5.5.8 server?
-Hank
On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL)
Also, can I do this:
insert into federated_table select * from local_table?
-Hank
On Tue, Jan 4, 2011 at 4:15 PM, Shawn Green (MySQL)
shawn.l.gr...@oracle.com wrote:
On 1/4/2011 15:53, Hank wrote:
Hello,
I have a background process that runs as a combination of PHPMySQL.
The
end
Nevermind -- it's working absolutely perfectly between 5.5.8 and 4.1.x.
Thanks again for the push.
-Hank
On Tue, Jan 4, 2011 at 5:14 PM, Hank hes...@gmail.com wrote:
Also, can I do this:
insert into federated_table select * from local_table?
-Hank
On Tue, Jan 4, 2011 at 4:15 PM,
Well,
it is just to have a console that is able to connect to every database,
ODBC and videogames are one of the few things good about microsoft!
I used it to import export data from/to access/sql server/mysql/oracle.
Cheers
Claudio
2009/2/22 Haidong Ji haidong...@gmail.com
Hi,
Never
I want to write some programs to work with data from eveonline.com but my
installed database is MySQL and the data format they provide is a backup of
MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded
that and am willing to install it, I just want to know if there is a
There are products out there that convert from ms sql to MySql.
Though I would test them before trusting them
--Original Message--
From: Chris Rehm
To: mysql@lists.mysql.com
Subject: moving data to MySQL
Sent: Feb 21, 2009 10:47
I want to write some programs to work with data from
2009/2/21 Chris Rehm ch...@javadisciple.com
I want to write some programs to work with data from eveonline.com but my
installed database is MySQL and the data format they provide is a backup of
MSSQL. They recommend installing SQL Server 2005 Express and I've downloaded
that and am willing to
Hi,
Using ODBC Drivers and MS Access you can do the job.
This is a quick list of steps(if you need more in depth just ask):
Download ODBC drivers for MySQL from www.mysql.com
Install the ODBC drivers
Create a System Data Source Name that point to the MySQL database (Control
Panel-Administration
Hi,
Never thought of the MS Access solution, but it sounds interesting and I am
intrigued. If the data volume is not that big, it could be a quick and dirty
way of doing it.
Sql Server 2005 and Sql Server 2008 Integration Service (SSIS) can do this,
but as far as usability is concerned, it is a
I moved information about our school locks (serial numbers, combinations,
student, etc) from FileMaker to MySQL into a table called lockers and wrote PHP
pages so our teachers could record the locks returned at the end of the year.
Unfortunately, I missed transferring close to 200 locks.
I
Hi John,
Kebbel, John wrote:
I moved information about our school locks (serial numbers, combinations,
student,
etc) from FileMaker to MySQL into a table called lockers and wrote PHP pages so
our
teachers could record the locks returned at the end of the year. Unfortunately,
I
missed
I hope you're not about to try this for the first time on your
production data :-)
I dumped the lockers table before beginning my experiments. If I had trashed
lockers2 (my experimental file) in the process, I would have truncated it and
re-inserted the 1492 records from my batch file.
boll wrote:
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
boll schrieb:
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create
Dominik Klein wrote:
Did you check FAT-permissions?
When mounting a FAT-partition, you have to set explicit permissions
while mounting as FAT does not understand the unix permission concept.
Try to mount this way:
mount -t vfat -o uid=mysql,gid=mysql,rw,umask=007
/dev/[yourdevicename]
Hi-
Using MySQL 4.1.11 on Fedora 4.
I moved my data directory to a FAT partition in order to share it with
Windows dual-boot.
Now when I try to start mysqld normally, it fails with these messages in
the log:
060420 18:16:03 mysqld started
060420 18:16:03 [Warning] Can't create test file
Are there any variables here I can tune to try and increase the the query?
mysql show variables like '%buff%';
+-+---+
| Variable_name | Value |
+-+---+
| bdb_log_buffer_size | 262144|
| bulk_insert_buffer_size |
Hi Shawn,
Thanks for helping me out again! I've cut and pasted the answers below your
questions:
I would love to say how adequate your hardware should be but I have
forgotten what hardware you have, sorry! Would you mind re-posting all of
the specs for your DB server?
2 x 500Mhz CPUs
8GB Memory
How fast do your disks rotate? What kind of disk controller are you using
(ATA, SATA, SCSI, ...)? Are they in a RAID array or not. If they are what
RAID scheme are you using?
How big are your buffers and other working areas? (show variables like
'%buff%'; show variables like '%size%';). Your
How fast do your disks rotate? What kind of disk controller are you using
(ATA, SATA, SCSI, ...)? Are they in a RAID array or not. If they are what
RAID scheme are you using?
I had to ask about this one because I'm not too sure about these sort of
things. Apparently the box is using ESS disks on
J S wrote:
How fast do your disks rotate? What kind of disk controller are you
using
(ATA, SATA, SCSI, ...)? Are they in a RAID array or not. If they are what
RAID scheme are you using?
I had to ask about this one because I'm not too sure about these sort
of things. Apparently the box is using
SAN --- I think that's the key piece to this puzzle. It doesn't matter how
fat your network pipes are, you will always encounter some network lag
when reading or writing data from and to a SAN. There is an abstraction
layer that must bundle your request to the disk then translate it from the
I want to copy data from one table to another. However I need to do this
carefully because I haven't got much of space left. I was thinking of
maybe
selecting data from every 10 rows of the old table, inserting it into
the new table, then deleting those rows from the old table.
Could
Hi,
I want to copy data from one table to another. However I need to do this
carefully because I haven't got much of space left. I was thinking of maybe
selecting data from every 10 rows of the old table, inserting it into
the new table, then deleting those rows from the old table.
Could
J S wrote:
Hi,
I want to copy data from one table to another. However I need to do
this carefully because I haven't got much of space left. I was
thinking of maybe selecting data from every 10 rows of the old
table, inserting it into the new table, then deleting those rows from
the old
computer), that way you have all
your data backed up for just in case.
Kind Regards
SciBit MySQL Team
http://www.scibit.com
-Original Message-
From: J S [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
CC:
Subject: moving data
Sent: Thu, 02 Sep 2004 12:38:30 GMT
Received: Thu
Does anyone know of a good step-by-step document demonstrating moving the
data files of a 3.23.5x installation (5 databases, each with several tables)
to a new partition on the same Linux box. I want to do this before
upgrading to MySQL 4. I think I understand how to do it from reading the
docs,
Jeremy Proffitt wrote:
Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I
Dumb Question. I need to move my data from their current access database to my new
MySQL server through an ODBC connection. The tables on both ends are set up
identially. I have added a linked table to the access database called EXPARTAB1. The
data is in EXPARTAB. I tried: INSERT INTO
Hello,
Because most web providers will not allow
direct TCP/IP access to
MySQL servers, I am considering the following
strategy:
a) Save the proprietary database to a file
containing a series of SQL
CREATE TABLE and INSERT INTO calls.
b) Upload the SQL file to the server via FTP.
c)
I am adding a web interface to a Windows application I have written
that uses another proprietary database system. To allow for my
customers to use both Linux and WinNT based web servers, I have
settled on MySQL for the web database. I am working on a strategy for
allowing my customers to move
If I have mysql on server A and an identical version on server B, what is the easiest
way to move data in Table C from server A to server B?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
* Kemp Randy-W18971
If I have mysql on server A and an identical version on server B,
what is the easiest way to move data in Table C from server A to server B?
Asuming your databases are stored in /usr/local/mysql/var/ and the relevant
database is named database:
From Server A:
scp
Hi all,
I wish to migrate some Filemaker 5 databases over to MySQL on NT.
Some of the databases have hundreds of fields, so it would be great if I
could export in a format that I can just import without having to pre-set
all the fields.
Any experience/suggestions?
George Pitcher in Edinburgh
We will be moving our MySql databases from a Winnt server to a linux server. Can I
just copy the data files from one machine to the other? If not then how should I do
it?
Mat Murdock
Your mouse has moved. Windows must be restarted for the change to take
effect. Reboot
It depends on what version of MySQL you are running. MyISAM tables will
move across platforms fine, but ISAM tables will not. You could always
choose the failsafe and use mysqldump to dump the contents of your
database into a file, and then use that to reload the contents on the new
machine.
38 matches
Mail list logo
