learnt
On Tue, Mar 18, 2008 at 3:39 PM, Paul McCullagh <
[EMAIL PROTECTED]> wrote:
> Yes, definitely. Previous versions of PBXT built on Windows, so there
> can't be much work to get it going.
>
> But I don't think I will get around to firing up my Windows VM until
> after the conference...
>
> O
The following format can be supported by mysql.
The first is the pure insert statement.
The other is csv file.
On Tue, Mar 18, 2008 at 10:00 PM, Rajesh Mehrotra <[EMAIL PROTECTED]>
wrote:
>
> Have you tried the MySQL Migration Toolkit? Check
> http://www.mysql.com/products/tools/migration-toolkit
If you skip the extend insert during mysqldump ,the process of the restore
is painful.
On Fri, Mar 21, 2008 at 5:05 AM, dr_pompeii <[EMAIL PROTECTED]> wrote:
>
> Hi Rolando
>
> thanks for the reply
> it works, thanks,
>
> new command used
>
> mysqldump --opt --skip-extended-insert --password=XXX
Can't open and lock privilege tables: Table
'mysql.servers' doesn't exist
On Fri, Mar 21, 2008 at 4:23 AM, Brown, Charles <[EMAIL PROTECTED]> wrote:
> 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
> 'm
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
Hi Rolando
thanks for the reply
it works, thanks,
new command used
mysqldump --opt --skip-extended-insert --password=XXX --user=root somedb >
/home/Someuser/somepath/A.sql
but i see one difference
from windows
/*!4 ALTER TABLE `articulo` DISABLE KEYS */;
INSERT INTO `articulo`
(`idArtic
See below...
> -Original Message-
> From: John Taylor-Johnston [mailto:John.Taylor-
> [EMAIL PROTECTED]
> Sent: Thursday, March 20, 2008 2:17 PM
> To: Sebastian Mendel; mysql@lists.mysql.com
> Subject: Re: relational tables
>
> DROP TABLE IF EXISTS `person`;
> CREATE TABLE `person` (
>
Use --skip-extended-insert as another mysqldump option
-Original Message-
From: dr_pompeii [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 20, 2008 2:43 PM
To: mysql@lists.mysql.com
Subject: doubt: mysqldump in linux like windows
Hello guys
i have this situation
in widnows with the mysq
Sorry, I'm a top quoter. This is what I want to do. I'm still told there
re problems with my keys.
DROP TABLE IF EXISTS `person`;
CREATE TABLE `person` (
`person_id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`email` varchar(255) default NULL,
PRIMARY KEY (`person_id
Hello guys
i have this situation
in widnows with the mysql administrador i make backup
i saw in the x.sql these lines for example
/*!4 ALTER TABLE `articulo` DISABLE KEYS */;
INSERT INTO `articulo`
(`idArticulo`,`descripcion`,`stockactual`,`precioUnitario`,`precioUnitarioVenta`,`totalValor
At 3:25 PM -0300 3/20/08, Edson Noboru Yamada wrote:
On Thu, Mar 20, 2008 at 2:53 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
-P is only used when connecting to non-localhost addresses. Try adding
"-h 127.0.0.1" to your commandline.
It worked! Thank you!
You can also force a TCP/IP conn
Are the table structures identical ?
If so, you could just move the data files themselves.
Otherwise consider using
unload from table B into seperated format (mysql load format)
truncate table A
load data infile into table A
On Thu, Mar 20, 2008 at 2:20 PM, Daniel Brown <[EMAIL PROTECTED]> w
On Thu, Mar 20, 2008 at 2:53 PM, Dan Nelson <[EMAIL PROTECTED]> wrote:
>
>
> -P is only used when connecting to non-localhost addresses. Try adding
> "-h 127.0.0.1" to your commandline.
>
It worked! Thank you!
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
In the last episode (Mar 20), Edson Noboru Yamada said:
> I have a single machine with 2 mysql instances running. One of them
> was started like this:
>
> /home/y/libexec/mysqld --basedir=/home/mysql --datadir=/var/mysql/data
> --pid-file=/var/mysql/mysqld.pid --port=3306 --socket=/tmp/mysql.sock
Hi,
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 recronstruct the
table in DatabaseA then remove all data which are already in Tab
Hi,
I have a single machine with 2 mysql instances running. One of them was
started like this:
/home/y/libexec/mysqld --basedir=/home/mysql --datadir=/var/mysql/data
--pid-file=/var/mysql/mysqld.pid --port=3306 --socket=/tmp/mysql.sock
and, the other one, like this:
/home/y/libexec/mysqld --def
Great article. Got me on the right track.
Actual solution I went with was something like:
select
`vPamLearner`.`learnerId`,
`vPamLearner`.`usedName`,
`vPamLearner`.`surname`,
max(prComp.dateSubmitted) latestSubmitted,
max(prComp.FProgressReviewId) latestSubmittedId,
max(p
Hi,
On Thu, Mar 20, 2008 at 10:35 AM, Edward Corbett <[EMAIL PROTECTED]> wrote:
> Hi,
>
>
>
> I have a load of reviews in a table and, for each person I want to pull out
> the most recent review.
>
>
>
> So, if I wanted to do this for a single person I would order by date desc
> and use "limit
Hi,
I have a load of reviews in a table and, for each person I want to pull out
the most recent review.
So, if I wanted to do this for a single person I would order by date desc
and use "limit 1". But I'm not sure how to do this in bulk.
Thanks.
At 10:47 PM -0400 3/18/08, Sookhyun Yang wrote:
Dear all,
I have a question about the limitatin of table size.
If I use the InnoDB engine, I don't have to worry that the total size of
table is greater than the single filesize?
You can create an InnoDB tablespace that spans multiple files, yes.
Hi,
On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane <[EMAIL PROTECTED]> wrote:
> do binlog sequences just rollover back to 0 w/o a resetlogs? will it just
> automatically go back to mysqld.00 after mysqld.99? any replication
> implications?
>
> I know it sounds like a stupid question and I'
At 2:51 PM -0500 3/19/08, Brown, Charles 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 was told that
the cnf file allows security over ri
do binlog sequences just rollover back to 0 w/o a resetlogs? will it just
automatically go back to mysqld.00 after mysqld.99? any replication
implications?
I know it sounds like a stupid question and I'm sure the developers are
smart enought to have thought of that but we'll be crossing
Thanks for the help. However I found another solution which is to use the
following SELECT COUNT(ProductsPurchases.ProductID)+Products.ProductReview as
varProductCount, Products.Name, Products.ProductReviewFROM
ProductsPurchasesINNER JOIN Products ON Products.ProductID =
ProductsPurchases.Prod
Thanks Sebastian, but I now get the error message
[MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function
> Date: Thu, 20 Mar 2008 12:59:22 +0100> From: [EMAIL PROTECTED]> To:
> mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Sebastian
> Mendel schrieb:> > Ne
Neil Tompkins schrieb:
Thanks Sebastian, but I now get the error message
[MySQL][ODBC 3.51 Driver][mysqld-3.23.58]Invalid use of group function
i am not familiar with ODBC or MySQL 3.x
but possible just GROUP BY is missing
check the manual for your mysql version for the exact syntax
if this
Sebastian Mendel schrieb:
Neil Tompkins schrieb:
Hi
I want to order by the totalled fields varProductCount and
Products.ProductReviewDESC
just put them together, separated with comma, like it is written in the
manual
ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT(ProductsPu
Neil Tompkins schrieb:
Hi
I want to order by the totalled fields varProductCount and Products.ProductReviewDESC
just put them together, separated with comma, like it is written in the manual
ORDER BY varProductCount + Products.ProductReviewDESC,
COUNT(ProductsPurchases.ProductID)
--
MySQL
Hi
I want to order by the totalled fields varProductCount and
Products.ProductReviewDESC
Neil
> Date: Thu, 20 Mar 2008 11:36:30 +0100> From: [EMAIL PROTECTED]> To:
> mysql@lists.mysql.com> Subject: Re: ORDER BY calculated field> > Neil
> Tompkins schrieb:> > Hi,> > > > How do I achieve a
Neil Tompkins schrieb:
Hi,
How do I achieve a SQL statement to order my results based on two calculated fields for example :
what two calculated fields?
SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name,
Products.ProductReview
FROM ProductsPurchasesINNER JOIN Pro
Hi,
How do I achieve a SQL statement to order my results based on two calculated
fields for example :
SELECT COUNT(ProductsPurchases.ProductID) as varProductCount, Products.Name,
Products.ProductReview
FROM ProductsPurchasesINNER JOIN Products ON Products.ProductID =
ProductsPurchases.Produc
I would like to thank everyone who gave suggestions about how to fix the mysql
privileges. Here's what we did:
We did a mysqldump on the mysql table on the old machine.
We brought the mysqldump into the mysql table on the new machine
We ran mysql_fix_privilege_tables
We gave the commandf
33 matches
Mail list logo
