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 wrote:
>
> 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
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 PHP&MySQL.
>>
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) <
s
On 1/4/2011 15:53, Hank wrote:
Hello,
I have a background process that runs as a combination of PHP&MySQL. 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
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
> Hi,
>
> Never thought of the MS Acces
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 s
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
2009/2/21 Chris Rehm
> 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
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 eveon
"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.
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 transfer
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 |
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
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
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
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
m
> 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.
>
> Coul
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. optional
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 tab
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
* 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 /usr
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.
John
22 matches
Mail list logo
