copying table fo other database

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

Re: copying table fo other database

[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 to

Copying table to another 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

RE: Copying table to another server.

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 to another using mysqldump. Since the servers are different

Re: table is read only after copying table files to new server

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)

Re: table is read only after copying table files to new server

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 was

Re: table is read only after copying table files to new server

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 password and that didn't work when I did it, but I didn't restart mysql after running the command. Probably it

table is read only after copying table files to new server

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 new

Re: table is read only after copying table files to new server

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 called

Re: table is read only after copying table files to new server

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 the

Re: table is read only after copying table files to new server

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 password I tried that, and then

copying table

I tried to copy a table and got this mesagem, but I ´ve done this several times ago... Got error -1 from table handler

Copying table V.2.0

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

Re: Copying table V.2.0

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

copying table

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