[EMAIL PROTECTED] wrote:
> Hi to all!
>
> I have to transfer copy of the one table from one to other database.
> I was working with phpMyAdmin. I exported table in sql file but, when
> tried to Import it to other database I got
> Fatal error: Allowed memory size of 8388608 bytes exhausted (tried t
Hi to all!
I have to transfer copy of the one table from one to other database.
I was working with phpMyAdmin. I exported table in sql file but, when
tried to Import it to other database I got
Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to
allocate 806882 bytes)
Any idea how
terface Specialist
Pottawattamie County, Iowa
-Original Message-
From: Andrew Mull [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 11:17 AM
To: mysql@lists.mysql.com
Subject: Copying table to another server.
Hello,
I'm having a problem with moving a database from one server
Hello,
I'm having a problem with moving a database from one server to another using
mysqldump. Since the servers are different platforms, some ascii characters
are getting corrupted.
So, my thought was to copy the table from one database to the other via the
mysql interface.
I found this onl
Bennett Haselton wrote:
At 11:22 AM 8/17/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I had already run the command:
grant all on tracerlock.test to bhaselto identified by ""
and that didn't work when I did it, but I didn't restart mysql after
running the command. Probably it was the
Thanks. Actually, my ISP helped me out and got this fixed. Here's what
they wrote in the support log:
>>>
Due to the method that the databases were copied over, I went into mysql
used the grant option on all the databases to allow root access and ability
to alter all the databases. Once this w
Hi Bennett
I had a similar problem on my system a while back. With my particular
case, the problem was the the default priv's on the new server for it's
users did NOT include INSERT rights.
Basically what I'm saying is: these are the reasons for a table to be
(or appear to be) read-only:
1) Table
I searched on Google and I found this post from 2 years ago:
http://www.phpbuilder.com/mail/php-db/2001082/0212.php
suggesting that the way to do it would be to connect to MySQL as root and
run the command:
grant all on tracerlock.test to bhaselto identified by ""
I tried that, and then did "flus
At 05:54 PM 8/16/2003 -0400, Rajesh Kumar wrote:
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called "tracerlock"
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and
".frm" file for every table in
Bennett Haselton wrote:
I'm trying to port my MySQL tables for a database called "tracerlock"
from one server to another. On the old server, in the
/var/lib/mysql/tracerlock directory, there was a ".MYD", ".MYI" and
".frm" file for every table in the database. So after creating a
database cal
I'm trying to port my MySQL tables for a database called "tracerlock" from
one server to another. On the old server, in the /var/lib/mysql/tracerlock
directory, there was a ".MYD", ".MYI" and ".frm" file for every table in
the database. So after creating a database called "tracerlock" on the n
I tried to copy a table and got this mesagem, but I ´ve done this several
times ago...
Got error -1 from table handler
I think you need a new approach. It appears that update does not support the join you
are attempting.
It seems that you are trying to update
the value for a column from one table with the value of a column from another table.
If this is the case, i would use a shell script to first extract
Kevin thanks for your response. Here are the different errors for each SQl
command I enter.
Command: update tblSNLC,tblSNOrg set
tblSNOrg.OrgSponsor1=tblSNLC.SponsorFull where tblSNOrg.OrgZip=tblSNLC.Zip;
Error: Failed to execute SQL : SQL update tblSNLC,tblSNOrg set
tblSNOrg.OrgSponsor1=tblSN
Read the manual on INSERT statement. You can INSERT and SELECT at the
same time.
Alejandro Lujan Toro wrote:
>
> I have a calendar db, and in there a base table (with
> holidays and such). I need to create a table, exactly the
> same as the base (data included). Is there an easy way of
> doing t
I have a calendar db, and in there a base table (with
holidays and such). I need to create a table, exactly the
same as the base (data included). Is there an easy way of
doing this?..
Alejandro Lujan Toro
CAI: Centro de Aplicación de la Informática
Em
16 matches
Mail list logo
