On Mon, Aug 13, 2012 at 8:25 PM, Thufir wrote:
> Looking at:
>
> Group gmane.comp.db.mysql.general
> Description The main list for general MySQL discussion
> Address mysql@...
> Status posting allowed
> http://dir.gmane.org/gmane.comp.db.mysql.general
>
> It would really be nice if
I'm trying to install multiple instances of mysql on windows 7, 64bit. 3hrs
into the job, I'm not making progress. Does anyone have an idea?
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and C
ct: Re: Myisam won't support replication in an MySQL Cluster environment
Am 04.05.2012 06:45, schrieb Brown:
> Does anyone have idea or experienced in MySQL Cluster configured for
> bi-directional replication. Please advise me if you have to use NDBcluster
> engine in order t
Does anyone have idea or experienced in MySQL Cluster configured for
bi-directional replication. Please advise me if you have to use NDBcluster
engine in order to get replication between the data nodes. I'm using MYISAM on
several tables that will not replicate.
***
Does anyone have idea or experienced in MySQL Cluster configured for
bi-directional replication. Please advise me if you have to use NDBcluster
engine in order to get replication between the data nodes. I'm using MYISAM on
several tables that will not replicate.
***
I noticed that my replication stopped working after migrating to MySQL cluster.
My current engine is myisam. Does anyone have an idea why repl won't work. Do I
have to use the ndbengine?
This message is intended only for the use of the Addressee and
Sent from my iPhone
On May 3, 2012, at 1:02 PM, "Haluk Karamete" wrote:
> Please take a look at the following code and tell me if there is a way
> around it.
>
> if ($current_server_is_mysql):
>while ($row = mysql_fetch_assoc($RS)) {
> else:
>while( $row = sqlsrv_fetch_array( $RS, SQL
Hi Gurus,
I would like to set BIN-LOG maintenance procedure for my master. The master is
on a windows platform. I’m all for make it simple and clean therefore I’ve been
leaning toward the automatic BIN-LOG removal “expire-logs-days=7”. The
problem is for this option to work, it should be pre
Hello Nitin,
Please give Nitin a prize. What a quiet genius she is. Now, I get it. Now, I
can see clearly.
I’ve tried it and it worked.
Thanks so much.
From: Nitin Mehta [mailto:ntn...@yahoo.com]
Sent: Wednesday, May 02, 2012 11:25 PM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: Re
Hello Rick,
I think I'll go with your recommendations - but help me here a little bit.
Because all look fuzzy like a brain surgery. So make it simple and clean for me.
For the sake of simplicity, here is what my master has:
Database: db1
Tables: db1tb1, db1tb2, db1tb3
Database: db2
Table
Hello Rick,
What goes into your my.cnf slave ?
Given dbname1 and dbname2
-Original Message-
From: Rick James [mailto:rja...@yahoo-inc.com]
Sent: Wednesday, May 02, 2012 12:05 PM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: RE: Can the mysql replication limited to one
Well said. Thanks so much.
Sent from my iPhone
On Apr 29, 2012, at 8:02 AM, "Reindl Harald" wrote:
>
>
> Am 29.04.2012 14:50, schrieb Brown:
>> is a complain I received from one of my developer that after following our
>> MySQL
>> Cluster migration
are
parameters that have sustain me over the years. Now, I'm doing MySql Cluster
are they any more relevant.
Best regards,
From: Claudio Nanni [mailto:claudio.na...@gmail.com]
Sent: Sunday, April 29, 2012 4:29 AM
To: Brown, Charles
Cc: mysql@lists.mysql.com
Subject: Re: engine is now
Harald [mailto:h.rei...@thelounge.net]
Sent: Saturday, April 28, 2012 3:01 AM
To: mysql@lists.mysql.com
Subject: Re: engine is now innoDB instead of MyISAM.
Am 28.04.2012 09:00, schrieb Brown:
> We recently switched from MySQL community to Mysql clustered using Oracle
> supported MySQl. The p
Hello all,
We recently switched from MySQL community to Mysql clustered using Oracle
supported MySQl. The problem is, during our testing phase, we observed the
default engine is now innoDB instead of MyISAM. Any thoughts on that? We're not
getting the performance that we expected - any thoughts
On Tue, Apr 3, 2012 at 04:10, Johan De Meersman wrote:
> - Original Message -
>> From: "Singer X.J. Wang"
>>
>> Perhaps something called a VM can be use?
>
> Perhaps something called documentation can be provided?
>
> I also notice that the original poster seems to have vanished again, wh
: One inst has 39 columns- the other 40
Am 22.03.2012 05:41, schrieb Brown:
> Look man, there has to be someone out there that can tell me why one
> user table has 5 extra columns. Is it version related or my sysprog
> person missed out on a step. Its hard to believe that this problem
Look man, there has to be someone out there that can tell me why one user table
has 5 extra columns. Is it version related or my sysprog person missed out on a
step. Its hard to believe that this problem is unique to my site.
Hostchar(60)NO PRI
Userchar(16)NO
I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. See below for their
attributes. Is anyone out there has any idea why these tables are not the same?
Can someone help me.
Hostchar(60)NO
I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. Their USER table
attributes are not the same. One instance has 39 columns while the other has 42
columns. Can someone please help me here. Could it be because I'm runn
I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. Their USER table
attributes are not the same. One instance has 39 columns while the other has 42
columns. Can someone please help me here. Could it be because I'm runni
I have two mysql instances in my mysql cluster. I noticed that their
MysSQL.user tables do not have the same number of columns. Their USER table
attributes are not the same. One instance has 39 columns while the other has 42
columns. Can someone please help me here. Could it be because I'm runni
Hello johan
Here is what did the trick for me:
1. in mysql-inst1, I created like table called test.user
2. I used mysqldump to pipe test.user table from mysql-inst1 to mysql-inst2
3. in mysql-inst2, I did insert into mysql.user select from test.user
We are migrating from master-slave replication
dious. Help me I'm running out of
time.
-Original Message-
From: David Lerer [mailto:dle...@us.univision.com]
Sent: Friday, March 16, 2012 1:36 PM
To: Baron Schwartz; MySql; Brown, Charles
Subject: RE: how to sync mysql.user table between to two mysql instances
As a follow up ques
Can someone instruct me on how to sync mysql.user table between to two mysql
instances.
In other words, I wouild like to copy mysql.user from mysql-inst1 to
mysql-inst2 +
Thanks
This message is intended only for the use of the Addressee and
may con
On Mon, Sep 26, 2011 at 14:30, Michael Albert wrote:
> I don't suppose I am the first to notice this, but most of
> the pages on dev.mysql.com have been listed by google
> as "attack pages", e.g http://dev.mysql.com/downloads/.
> Has there been a problem, or is google being overzealous?
Here'
t for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
From: Andrew Moore [mailto:eroomy...@gmail.com]
Sent: Monday, June 13, 2011 11:13 AM
To: Brown, Charles
Cc: mysql@lists.mysq
Hello All ~ I attempted to do a mysqldump when I got this message -- see below:
mysqldump: unknown variable 'datadir=/var/lib/mysql'
Please can someone help me.
Thanks
This message is intended only for the use of the Addressee and
may contain in
On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote:
> Can smbd please look at this sentence - I got an error and do not
> know how to fix it - I am still very unfamiliar with MYSQL:
>
> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
> varchar(50), clock timestamp, action va
On Wed, Dec 29, 2010 at 04:57, Hajo Locke wrote:
> Hello,
>
> i want to talk from php to different mysql-servers with different versions.
> is it a recommend way to compile php always against newest libmysqlclient or
> not so important?
You should use the newest stable version so you can take
On Tue, Dec 14, 2010 at 13:58, omar zorgui wrote:
> Hello,
>
> How can i subscribe for this list
http://lists.mysql.com/mysql?sub=1
--
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
--
MySQL General Mailing List
For list archiv
On Tue, Dec 14, 2010 at 12:52, Patrice Olivier-Wilson wrote:
> On 12/14/10 12:51 PM, Patrice Olivier-Wilson wrote:
>>
>> I have a question that this list solved a year ago, and I can't remember
>> what the solution was. Does this list have an archive?
>>
>> (Sorry if it is on one of the links to t
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote:
> Hi all,
>
> Is there a list/form to get some help on compiling mySQL queries? I am
> executing them via PHP, but do not want to ask for help here if it is no the
> appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL
Hello All ~ I'm experiencing some high load averages on mysql server between
the hrs 9am - noon. We don't have the MySQL optimal performance monitor. I'm
wondering whether if there's a log or an area that I should be looking at to
get an idea of what the problem going on with MySQL.
Thanks
Hello All ~ I'm experiencing some high load averages on mysql server between
the hrs 9am - noon. We don't have the MySQL optimal performance monitor. I'm
wondering whether if there's a log or an area that I should be looking at to
get an idea of what the problem going on with MySQL.
Thanks
On Fri, Jun 18, 2010 at 16:30, Dave wrote:
> SELECT * FROM contacts WHERE state = 'CA' and name = 'bob' or
> name = 'sam' or name = 'sara'
We begin by asking on the right list (mysql@lists.mysql.com, CC'd
by courtesy).
You're on the right track though. Try a WHERE...IN statem
[Top-post.]
You'll probably have much better luck on the MySQL General list.
CC'ed on this email.
On Tue, Jun 15, 2010 at 20:58, Jan Reiter wrote:
> Hi folks!
>
> I'm kind of ashamed to ask a question, as I haven't followed this list very
> much lately.
>
>
>
> This isn't exactly a PHP
Hello All. when I issued this command: ps -e | grep, I noticed that
mysqld_safe was up running in my system.
My question is: what is mysqld_safe and why was it running. Please help.
[sp...@naxbmisq03 ~]$ ps -e | grep -i mysql
11989 ?00:00:00 mysqld_safe
12025 ?13:28:39 mysqld
On Sat, Jan 30, 2010 at 01:49, Vikram A wrote:
> Dear Admin,
>
> I would like to share and get inputs from experts on MYSQL Db.
>
> I request you to grant access to me.
You may not have noticed, but you're already posting to the list.
All you have to do is subscribe and you have full access.
Can someone help me. I am trying to make calls to Mysql from VBscript via ASP
But I'm experiencing difficulties with passing host variables to mysql
See examples below
isbn =34373
sql= "select isbn, book_title, publisher_name FROM cs443.books_available where
isbn= " &isbn
The above works but
Can someone help me. I am trying to make calls to Mysql from VBscript via=
=20ASP But I'm experiencing difficulties with passing host variables to my
SQL=20 See example below
isbn =3D 717192=20
sql=3D "select isbn, book_title, publisher_name FROM cs443.books_availabl= e
where isbn=3D " &isbn
Please look in /etc/my.cnf
If not found create one. Of cause, MySQL can start and run without a 'my.cnf'
file that’s why you couldn't find one. In the absence of the my.cnf file,
MySQL will use default for every parameter .
Charles,
-Original Message-
From: walter harms [mailto:wha
From: Brown, Charles
Sent: Tuesday, November 03, 2009 2:54 PM
To: Ramsey, Robert L; mysql@lists.mysql.com
Subject: socket '/tmp/mysql.sock' (2)
Hello All, I desperately need your help.
I migrated from version 5.0.27
To version 5.0.77
H
Hello All, I desperately need your help.
I migrated from version 5.0.27
To version 5.0.77
Here is the command I used to migrate my databases:
mysqldump -ux -px --all-databases --master-data | mysql -h88.88.89.889
-ur -px
Problem: after the migration, I have been getting t
Jaime Crespo Rincón [mailto:jcre...@warp.es]
Sent: Thursday, October 08, 2009 10:17 AM
To: Brown, Charles
Cc: Daevid Vincent; mysql@lists.mysql.com
Subject: Re: MYSQL slow query log in table.
2009/10/7 Brown, Charles :
> Hello All. I would like to implement MYSQL slow query log in table. Can
&
Hello All. I would like to implement MYSQL slow query log in table. Can
someone kindly assist me with the table definition and implementation.
Thanks so much in advance
This message is intended only for the use of the Addressee and
may contain inf
Questions Folks:
(1) What do you about un-index searches. How can one report and monitor them?
(2) What do you do with the slow-query log. Are there any utilities or scripts
out there to filter and manage this log?
Thanks
This message is intended
Just as a heads-up, in case you guys weren't yet aware (cross-posting):
Elance.com was the victim of an SQL injection attack earlier this
summer (they apparently missed our billions of threads on sanity).
According to their folks, only names, company names, phone numbers,
and email address
On Mon, Jul 20, 2009 at 15:03, Dave Shariff Yadallee - System
Administrator a.k.a. The Root of the Problem
wrote:
> Hello, we are trying to move a Joomla Site
> and the administrator does nowrk.
>
> Using MySQL 5.1.36 on MAC OS X Server.
>
> How can I fix this?
This would be a question to ask
Chris;
From my understanding of your question, your message (included
below in its entirety) is better sent to the MySQL General list, which
I've CC'd on this reply. If you haven't yet, please subscribe there
at mysql-subscr...@lists.mysql.com to follow the thread for responses.
If I
On Sun, Apr 19, 2009 at 23:42, Cameron Rogers wrote:
> Hi everyone. I am starting my first web site. I have a temporary contract
> with godaddy but know there are better options out there. The only problem
> is, I don't know reliable sources to research which hosting program to use.
> Any reco
On Mon, Mar 30, 2009 at 19:45, Dian Crayne wrote:
> Chuck Crayne (ccra...@crayne.org) has died. I am his widow.
> I cannot unsubscribe him from this list because I do not
> have his user name and password. Please remove him from your
> membership list. If you need to talk to me about this, my
It mentions that root in MySQL has nothing to do with the root of Mac
OSX, but I need to know if MySQL being unprotected in this way has
opened a door for hackers.
it means that they can do whatever they want to the mysql db's without
being prompted for a password. This does not mean th
On Mon, Feb 2, 2009 at 13:43, Martin Gainty wrote:
>
> select ADDRESS FROM FUBAR_TABLE WHERE MOD(TO_
> NUMBER(SUBSTR(ADDRESS,1,instr(ADDRESS,' ',1))),2) =0;
That hit the nail right on the head. That was the same thing I
was going to suggest, Martin. I think people tend to forget that
MySQL
On Thu, Jan 15, 2009 at 20:44, Daevid Vincent wrote:
> I've been tasked with cleaning up a bunch of 'eventum' tables that got
> accidentally dumped into several databases and then replicated.
>
> I'm wondering if I can just go through with a simple command to blow
> these all away:
>
> find /var/
On Wed, Nov 12, 2008 at 12:35 PM, Shain Miley <[EMAIL PROTECTED]> wrote:
> Hello all,
> I was wondering if anyone had any good insight into running the 32 bit and
> 64 bit versions of MySQL? We are going to be using a replication setup
> within my organization very shortly. We intend to a have
According to the doc for this parameter, "Possible removals happen at
startup and at binary log rotation." This implies that removal is not
automatic - you have to either flush logs or bounce the server. We use
"Purge Master" periodically.
i do this from cron
mysql -e "PURGE MASTER LOGS
Can someone tell me why I am getting this message whenever I issued a
"CHANGE MASTER" command?
@4000489f38462d0bedd4 080810 13:49:32 [ERROR] Failed to initialize
the master info structure
Thanks
This message is intended only for the use of the Add
Here is what I'm getting
mysql> change master to master_host = 'naxbmisq01.bmi.com', master_user
= 'repl', master_password = 'repl';
ERROR 1201 (HY000): Could not initialize master info structure; more
error messages can be found in the MySQL error log
mysql> reset slave;
Query OK, 0 rows affecte
Re: You can tell mysql to not keep relay logs that have already been
used.
What command does this
-Original Message-
From: David Giragosian [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2008 12:54 PM
To: mysql@lists.mysql.com
Subject: Re: can some please help me -- REPLICATION
On
The background:
We are doing replication. The file-system containing the SLAVE's
relay-log got filled to capacity. Later on, I noticed replication has
not been working for the last month or more.
My Action:
I deleted the 2 oldest relay-log then attempted to restart SLAVE. Now,
the SLAVE will not
Could not initialize master info structure;
Can someone help me. I am getting the above message
This message is intended only for the use of the Addressee and
may contain information that is PRIVILEGED and CONFIDENTIAL.
If you are not the intended re
Please advise me on how to restart MYSQL slave instance.
All efforts have failed. When I issued the "START SLAVE" command it came
back with an error -- see below.
ERROR 29 (HY000): File './naxbmisq02-relay-bin.000157' not found
(Errcode: 2
I inadvertently deleted this file.
Tha
On Wed, Jul 23, 2008 at 12:10 PM, <[EMAIL PROTECTED]> wrote:
> Yes, sorry. I have a database that records ip of attacks on a customer
> server, what I like to do get a count so that I can see what subnet is
> doing the major of the attacks.
>
> select ip from ipslimit 10;
> +-+
On Wed, Jul 23, 2008 at 11:45 AM, <[EMAIL PROTECTED]> wrote:
> Guys,
>
> I have been fighting with mysql trying to get it to only show every after
> the last dot(.) on a ip. for example
>
> instead geting 10.0.0.0 only get 10.0.0
As pulled from a database row? Sorry, I didn't quite understan
I run 4.1.20 in master/master for nagios clustering. Everything was
working fine until both machines went down due to power failure in the
IDC. On powering back up one of the machines has come back fine but on
the 'secondary' bearing in mind this is master/master but actually the
01 machin
Hi
I run 4.1.20 in master/master for nagios clustering. Everything was
working fine until both machines went down due to power failure in the
IDC. On powering back up one of the machines has come back fine but on
the 'secondary' bearing in mind this is master/master but actually the
01 machi
I don't think you need to flush your bin logs.
CHANGE MASTER TO MASTER HOST = 'hostname';
Look at this for more info at
http://dev.mysql.com/doc/refman/5.0/en/change-master-to.html
There is a lot more you can add to the statement.
thanks but this gave me a very similar error - I forget
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
'./devnagios01-
Hi
I had master-master working fin in dev - i move them to prd now and so
change the hostnames, on starting i see this error
080522 11:53:40 mysqld started
080522 11:53:40 InnoDB: Started; log sequence number 0 213274351
080522 11:53:40 [ERROR] Failed to open the relay log
'./devnagios01-re
Yes thanks - i have done that and restarted the slave and _some_
tables now appear to update but others dont
eg
master:
mysql> select count(*) from tbl_checkcommand;
+--+
| count(*) |
+--+
| 30 |
+--+
1 row in set (0.00 sec)
slave:
mysql> select count(*) from
The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side) using :
slave-skip-errors=1062
This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.
Yes thanks - i have done tha
Hi
I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have
setup a master/slave combination. Updates at first appeared to work as
creating and inserting into the master created the db's on the slave
etc. I have noticed however that data in the master is not making its
way to t
On Wed, Apr 16, 2008 at 1:18 PM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
>
> is there any command that can set so that admin's privileges on internal =
> admin's privileges on test???
>
> what i'm trying to avoid is manually adjust admin's privileges on test if
> admin's privileges on internal cha
On Tue, Apr 15, 2008 at 9:03 AM, Hiep Nguyen <[EMAIL PROTECTED]> wrote:
> hi all, i have an existing database (internal) with a user named 'admin',
> everything works fine as far as privileges concern.
>
> i just created a new database (test) and want to grant admin's privileges
> on test as same
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> Iam having the one table name called AccessDetails and data inside that
> tables is following,
>
[snip=schema]
>
> In that , I need to calculate the number of total sites , number of
> total Accessed Sites,num
On Tue, Apr 15, 2008 at 3:11 PM, minky arora <[EMAIL PROTECTED]> wrote:
> Hi Gurus,
> I am a newbie.Please bear with me.
> Could someone pls guide me as to the best way of adding excel files as
> tables to Mysql ?
mysqldump is for exporting data. What you're looking for is the
"LOAD DATA [
On Tue, Apr 15, 2008 at 2:20 PM, B. Keith Murphy <[EMAIL PROTECTED]> wrote:
> Hey everyone,
>
> I just posted the Spring issue of the MySQL Magazine. This issue contains
> a great group of articles that you will want to read. In addition, Sheeri
> Cabral did a fabulous job with a new layout for
Ratheesh,
There's a specific list for PHP database functions, "Databases and
PHP" (PHP-DB), which you can find at http://php.net/mailinglists .
I'm forwarding your message over to there, and recommend that you
subscribe to that list. You'll probably get more direct responses by
narrowing-
On Mon, Apr 14, 2008 at 3:45 PM, Daniel Brown <[EMAIL PROTECTED]> wrote:
>
> Does your file actually have the characters \t \t \n at the end of
> each row like that?
>
> Send it to me as an attachment off-list and I'll help you figure
> it out and then
On Mon, Apr 14, 2008 at 3:33 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
>
> On Apr 14, 2008, at 3:29 PM, Daniel Brown wrote:
> >
> > That's because it's attempting to insert the name of the columns
> > from your CSV into MySQL --- and 'Record'
On Mon, Apr 14, 2008 at 1:29 PM, Jason Pruim <[EMAIL PROTECTED]> wrote:
> Hi Everyone,
>
> I am attempting to use this command: load data infile
> '/volumes/raider/elks.test.txt' into table elksCurrent fields terminated by
> '\t' lines terminated by '\n';
[snip!]
>
> The error that I'm getting is
exactly what I was looking for. Thank you all very much.
Larry
--
Larry Brown <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
I have a slew of records that went to the wrong database. The tables
have the same names and now I want to copy those records over to the
correct database. Is there such a mechanism using the cli mysql
application in Linux?
Larry
--
MySQL General Mailing List
For list archives: http://lists.
On Tue, Apr 8, 2008 at 7:28 AM, Steven Macintyre
<[EMAIL PROTECTED]> wrote:
> Hi all,
>
> I have the following SQL statement;
>
> SELECT count( salesID ) AS count, branch_name, company_name, branch.branchID
> FROM sales
> LEFT JOIN IGuser ON sales.IGuid = IGuser.IGuid
> L
On Sun, Mar 30, 2008 at 9:59 AM, Velen <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> How can i limit connections to my database?
RTFM: http://dev.mysql.com/doc/refman/5.0/en/user-resources.html
--
Forensic Services, Senior Unix Engineer
1+ (570-) 362-0283
--
MySQL General Mailing List
For list
On Mon, Mar 31, 2008 at 9:39 AM, Kaushal Shriyan
<[EMAIL PROTECTED]> wrote:
> Hi
>
> Is there a documentation on replication of MySQL Database on Gentoo
From the manual:
http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html
--
Forensic Services, Senior Unix Engineer
1+ (570
On Fri, Mar 21, 2008 at 10:04 AM, Velen <[EMAIL PROTECTED]> wrote:
> This one is alright but is there an alternative that can be run with the
> mysql> prompt?
Not to dump a file, but to import, yes. Check out the LOAD DATA
INFILE command:
http://dev.mysql.com/doc/refman/5.0/en/load-d
On Fri, Mar 21, 2008 at 9:14 AM, Velen <[EMAIL PROTECTED]> wrote:
> This does not solve my problem. DatabaseA and DatabaseB are on 2 seperate
> pc and the only communication that can be use between the two PC is a USB
> pendrive.
>
> Is there another way of copying a table from one Database to
Hey Folks.
I'm getting this error -- I need your input or help.
080320 15:02:16 [ERROR] Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
080320 15:02:16 [Note] Event Scheduler: Loaded 0 events
080320 15:02:16 [Note] E:\Apps\Standard\HPRUM\MYSQL\bin\mysqld: ready
for con
On Thu, Mar 20, 2008 at 1:41 PM, Velen <[EMAIL PROTECTED]> wrote:
>
> Actually I am updating TableA in DatabaseA with values from TableB in
> DatabaseB. Database B is on a stand alone PC. I'm using VB6 to create a
> .txt file containing data from TableB then using VB6 once more to
> recronstr
On Wed, Mar 19, 2008 at 3:51 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> I inherited a mysql server database. Stuff are not documented. My
> question is: Are there any security work-arounds in mysql. I have access
> to the cnf file. I need to get in and dump the database.
I inherited a mysql server database. Stuff are not documented. My
question is: Are there any security work-arounds in mysql. I have access
to the cnf file. I need to get in and dump the database. I was told that
the cnf file allows security over rides. Please help
I have tried mysql -uroot. It
On Wed, Mar 19, 2008 at 12:15 PM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> Using mysqldump, I'm about to dump all databases and import to another
> instance - new . My question is do I need to define all security and
> users in the new mysql or the security definitions
Using mysqldump, I'm about to dump all databases and import to another
instance - new . My question is do I need to define all security and
users in the new mysql or the security definitions and privileges will
be included in the dump file created by mysqldump. What is the function
of mysql_fix_p
Here is a follow-up question: Using mysqldump, I'm about to dump all
databases and import to another instance - new . My question is do I
need to define all security and users in the new mysql or the security
definitions and privileges will be included in the dump file created by
mysqldump.
Pl
action. And with
that forced lesson, hopefully they'll learn that the prompt is the
safer way of doing this. Again, though, that's the off-the-wall
possibility. A "Learn or Die" ultimatum.
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
r if you're patient.
If you can't wait (or don't feel like it), check out the forum at
http://www.mysqlfreaks.com/.
Best of luck, Marco!
--
Daniel P. Brown
Senior Unix Geek
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ith the user information?
>
> Thanks,
> Terry
> nohup mysqldump -h -u -p
> --all-databases --routines --triggers | mysql -h Machine> -A
Yes, the --all-databases flag recursively copies all databases and
tables, including the 'mysql' database with user and time
On Mon, Mar 10, 2008 at 3:26 PM, Tim McDaniel <[EMAIL PROTECTED]> wrote:
> On Mon, 10 Mar 2008, Daniel Brown <[EMAIL PROTECTED]> wrote:
> > The same question just received an excellent answer from Rolando
> >Edwards about ten minutes ago. Check the archive h
1 - 100 of 347 matches
Mail list logo
