AW: How can i duplocate a database???? i 've tried mysqldump can get it towork ANy ideas??

[Tobias Wolff]

Hi Jorge,
you usually do something like

mysqldump -u USER -p TABLE  FILE

where TABLE is dumped to the FILE. USER must have privileges to do so (I
usually take the superuser).

The other way around you simply have to do

mysql -u USER -p TABLE  FILE

Should work then,
Tobias.

-Ursprngliche Nachricht-
Von: Jorge Cordero [mailto:[EMAIL PROTECTED]]
Gesendet: Freitag, 9. Mrz 2001 04:31
An: mysql
Betreff: How can i duplocate a database i 've tried mysqldump can
get it towork ANy ideas??


I am trying to make several copies of a database i have tried
 mysqldump -databasename can some one throw a piece of code please;

Thanks


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Duplicate Entry in Key 1

[Tobias Wolff]

Hello,
I have searched the mailing list for this topic, but didn't find a match vor
my problem.

I am working on Linux Mandrake with MySQL 3.23.33 installed from the RPMs
for Mandrake. I am trying to convert a ACCESS database to MySQL using a perl
script. The script makes connections to the ACCESS database via ODBC and to
the MySQL database. The script works find in converting several tables. On
one table it fails with saying "duplicate entry in key 1" with "key 1" being
the primary key. Two funny things:

1. There isn't a duplicate entry for this key. Checked this over and over
again.
2. It is not the same key. Each time I run the script it gives me a
different key. Of course, I do drop the table first.

Can someone help me??
Thanks,
Tobias.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

AW: PHP and MySQL

[Tobias Wolff]

You have to edit your "php.ini" file, usually located in /usr/local/lib.

There is an option called "mysql.default_socket". The value of this options
is the path to the mysql socket file. Your systems seems to search the
socket file at "/var/lib/mysql/mysql.sock". It might be at a different
place, probably "/tmp/mysql.sock".

Tobias.

-Ursprngliche Nachricht-
Von: root [mailto:root]Im Auftrag von Ben Kennish
Gesendet: Donnerstag, 1. Mrz 2001 11:56
An: [EMAIL PROTECTED]
Betreff: PHP and MySQL


Who would've thought it would take 3 days to install MySQL, PHP and get
them talking???!!

I've installed PHP 4.0.4pl1 using an RPM from www.redhat.com

I've also installed MySQL (latest ver) server and client versions from
www.mysql.com using RPMs.

Now MySQL seems to be up and working (using 'mysql' and 'mysqladmin'
gives me no trouble) and PHP seems to work fine ?php phpinfo(); ?.

I've installed the PHP-MySQL module from redhat.com (a single file -
mysql.so) and uncommented the "extension=mysql.so" line in /etc/php.ini

But when I type ...

mysql_connect('localhost', 'root', 'b');

into a PHP file, (I set b as my root SQL pwd) I get the following
error...

"Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/var/lib/mysql/mysql.sock' (111) in
/var/www/html/index.php on line 5"

There seems to be nothing in the MySQL error log.

Please help!  Thanks,

--
Ben Kennish

Software Developer
Fubra Limited

web   | www.fubra.net
email | [EMAIL PROTECTED]
phone | +44 (0)870 1222 600
fax   | +44 (0)870 1222 699

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

EXPLAIN with unexpected result.

[Tobias Wolff]

Hello,
I'm slightly stunned seeing a result from the EXPLAIN statement.

I have a table "T" with columns "a", "b", "c", "d" and a multi-column index
on (a, b, c)

I perform a query:

EXPLAIN SELECT * FROM T WHERE a = some_value, d = some_value, b =
some_value

The result tells me that MySQL is taking index (a, b, c). Why?

Furthermore, when I add another multi-column index (a, d, b) to match the
query above, EXPLAIN still tells me that it uses index (a, b, c).

Can someone enlighten my on this one???
Thanks,
Tobias.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Switching from 3.22.32 to 3.23.33. What about the database files?

[Tobias Wolff]

Hello,
can anyone tell me whether or not I have to convert the database files when
switching from MySQL Version 3.22.32 to Version 3.23.33. I am working on
SuSe Linux 6.4. Is it sufficient just to copy the database files?
Thanks,
Tobias.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php