[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
It should just exit unless you are using -p with mysql. In that case, if
mysqldump got an access denied, nothing would output to stdout and mysql
would be left waiting for a password.
I would try the following:
>mysqladmin -h 'other_hostname' create db_name
>mysqldump --opt db_name > dump.sql
>my
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
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
