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
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
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.
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?
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
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
A)
0. optionally: start transaction;
1. create temporary table mytemptable select * from mytable order by mytableprimarykey
limit 10;
2. insert into destinationtable select * from mytemptable;
3. delete * from mytable order by mytableprimarykey limit 10;
4. drop mytemptable;
5.
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)
* 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
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.
22 matches
Mail list logo