Whatever you name it
Wherever you place it
Mysqldump (options) > filename
--Original Message--
From: Nanu Kalmanovitz
Sender:
To: mysql@lists.mysql.com
Sent: Aug 22, 2008 23:48
Subject: mysqldump questions
Hi!
What is the name dumped file and where it is created?
System is :Novell 6
Hi!
What is the name dumped file and where it is created?
System is :Novell 6.5 sp6 - Apache 2, MySQL ver. 4.0.26, PHP 5.2.3.
TIA
Nanu
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
David,
>My goal is to create a report, that lists the Top 100 most expensive
BookNames, for every CategoryId in this table.
I think you can map the example under "Within-group quotas (Top N per
group)" at http://www.artfulsoftware.com/infotree/queries.php to your
requirement.
PB
David Per
hola amigosss...cuanto tiempo no? sorry por la ingratitud!
COMO ESTAN? ESTO VA PARA LAS PERSONAS QUE QUIERO Y QUE NECESITO QUE ME
ACOMPAÑEN DE CORAZÓN EN ESTE DIA TAN ESPECIAL PARA MI...
LES COMENTO QUE HE TOMADO UNA DECISION IMPORTANTE EN MI VIDA... BUENO POR
LO PRONTO EL CIVIL, TAL VEZ CREAN QU
Hello,
I've been looking through the documentation/list and haven't found anything
directly on this subject. It's possible that I'm just not looking in the right
place.
I would like to log all failed authentications to the server. It would be nice
to be able to log the attempted user name
Hi MySQL Users-
I have a query problem I have been working on for quite some time and I am
really at a loss to find a native function(s) to handle my task.
I have this table:
CREATE TABLE BookCategoryMetrics (
BookName VARCHAR(255),
CategoryId VARCHAR(128),
RatingSum DOUBLE,
Cost DOUBLE,
PRIMARY
As I said, it appears your mysqldump output is not doing a "DROP TABLE"
before each create. You need to correct that. Do the drop table commands
yourself, then load the tables. Afterwards, do a "FLUSH PRIVILEGES" to
activate the new permissions.l
2008/8/22 Deniss Hennesy <[EMAIL PROTECTED]>
>
You're restoring the mysql database itself, do you mean to do this? You
probably do if it's a new server but there already exists a mysql database
so, unless your restore program does "DROP TABLE" before each create, you'll
keep getting this error.
On Fri, Aug 22, 2008 at 10:22 AM, Deniss Hennesy
Hi to list
i ve installed new server. while i was restoring my backup to this server.
i took this error and restoring procees is to stop.
*ERROR 1050 ( ) at line : Table 'columns_priv' already exists*
My old server mysql version is mysql-client-4.0.20 is running on old
server but mys
>-Original Message-
>From: Andy Shellam [mailto:[EMAIL PROTECTED]
>Sent: Friday, August 22, 2008 4:39 AM
>To: mysql@lists.mysql.com
>Subject: Re: Zip Codes with Leading Zeros
>
>FYI, we have the same issue with exporting phone numbers from MS SQL.
>All phones numbers
>in the UK start with z
>-Original Message-
>From: Keith Spiller [mailto:[EMAIL PROTECTED]
>Sent: Thursday, August 21, 2008 10:12 PM
>To: mysql@lists.mysql.com
>Subject: Zip Codes with Leading Zeros
>
>Hi,
>
>RE: Zip Codes with Leading Zeros
>
>We need to export a MySQL table with a zip code field to Excel. We
>
I'm new to bin-logging and replication. I have a database, about 3GB that I
have been converting data off of an old system into this new one. The basic
procedure is to take the database offline at 10PM once a week, export the
entire DB as an SQL file using mysqldump then download and import it into
You really need different config files if you're going to log anything or if
you need different server ids. You should also use different sockets. You
can stop a specific server by specifying the host on the mysqladmin shutdown
command.
I did it by keeping everything different, including the nam
Keith Spiller schrieb:
Hi Johnny,
Yeah. Sadly I missed the fact that the zip codes were hacked in our original
Works to MySQL conversion until long after I had imported the data into our
current MySQL table. Now we have to fix the numbers in our MySQL table and
guarantee that we can expor
Hi Keith,
I don't know how to fix it in MySQL, but if you import them into
Excel, select the zip code field, go under format rows under the
"Special" option is Zip Code. If you use that it will add a leading
zero to any field that does NOT have at least 5 characters.
Also.. If you have ad
Hi All,
I am asking a very simple question.
I need to install two mysql service (instances) on the same server.
I know we can do that using different port, but should i use two different
my.cnf files, and also, what is the procedure to stop one mysql service and
keep other one running.
regards
an
FYI, we have the same issue with exporting phone numbers from MS SQL.
All phones numbers
in the UK start with zero which causes no end of grief when exporting
data to Excel.
Even if we then change the column data type to "text", it doesn't put
the zeros back in
(it's like Excel has deleted
FYI the manual for 5.0 recommends upgrading to 4.1 first.
"As a general rule, we recommend that when upgrading from one release
series to another, you should go to the next series rather than
skipping a series. If you wish to upgrade from a release series
previous to MySQL 4.1, you should u
hi guys,
I used powerbuilder to connect MySQL database,but it
seems like that powerbuilder can not call stored
procedure in my database.
It said "the database does not currently support
retrieval of procedure text".
Is this ok? or I was wrong somewhere.
Thanks.
*^_^*
_
19 matches
Mail list logo
