hello,
i have this SQL code in a python programme but i wanted to change the
SQL so that it returns totals for each date. or do i have to make a
loop for each date range so that i get the following results which
then i would like to plot on a graph.
$ python daily_totals.py
(2L,
hello,
i had a master-master replication now one of the masters seems to be
about two days ahead of the slave
how do i make the first server in sync with the second and force any
data added to the second master to be pushed back into the first
server.
thanks
--
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ
hello,
i have a working master-slave replication, the problem i find is that
if i restart the MASTER there is a difference in the MASTER_LOG_FILE
and MASTER_LOG_POS on the SLAVE.
what is the correct way to keep the two slaves in sync even after i
restart the server. the way i do it now is to:
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
On Thu, Aug 26, 2010 at 3:09 PM, a.sm...@ukgrid.net wrote:
That is really bad, you will loose changes.
You shouldnt have to do anything when rebooting either
thanks
On Wed, Aug 18, 2010 at 10:42 PM, a.sm...@ukgrid.net wrote:
Quoting Norman Khine nor...@khine.net:
What is shown from show master status and show slave status after you
have made a change on the master DB?
this is the output:
http://pastie.org/1100610
it does not seem to have
hello,
i have an issue with the replication here is my procedure:
http://pastie.org/1100368
in the log it shows replication works, but when i update a record this
is not updated on the server.
any help much appreciated.
--
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ
hi
On Wed, Aug 18, 2010 at 8:00 PM, a.sm...@ukgrid.net wrote:
Quoting Norman Khine nor...@khine.net:
hello,
i have an issue with the replication here is my procedure:
http://pastie.org/1100368
in the log it shows replication works, but when i update a record this
is not updated
hello, i have a table called checkout, this has a row called products
which has contains a python dictionary data, like
http://pastie.org/1082137
{products: [{productId: 123, productName: APPLE,
productPrice: 2.34, productUrl: http://appple-fruits.net,
productDescription: nice juicy
Hello,
I don't know what I am missing, but I have this:
mysql SELECT url FROM product WHERE url IS NULL;
Empty set (0.05 sec)
mysql SELECT url FROM product WHERE product_Id = 67;
+--+
| url |
+--+
| |
+--+
1 row in set (0.00 sec)
what goes with this, how can i ensure that this
thank you, this makes sense.
On Thu, Jul 29, 2010 at 11:29 PM, Dan Nelson dnel...@allantgroup.com wrote:
In the last episode (Jul 29), Norman Khine said:
I don't know what I am missing, but I have this:
mysql SELECT url FROM product WHERE url IS NULL;
Empty set (0.05 sec)
mysql SELECT url
this is solved and this post helped me:
http://www.buildcms.com/cms_knowledgebase/how_to_recover_mysql_data_from_innodb
On Fri, Jul 23, 2010 at 8:39 PM, Norman Khine nor...@khine.net wrote:
Hello,
I have a server which has been booted in rescue mode, i have copied
the /mnt/var/lib/mysql/blog
Hello,
I have a server which has been booted in rescue mode, i have copied
the /mnt/var/lib/mysql/blog folder to another server running MySQL and
copied this folder to /var/lib/mysql
when i connect to the mysql cli, i get this:
http://pastie.org/1057117
but my source server is 64bit where as
hello, i have a mysql database that stores URL's in a table now i
would like to change the schema so that the URL's are unique so my
question is: is it appropriate to use URL's as a unique IDs if not
what are the alternatives?
any advise much appreciated
norman
--
˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ
hello,
i have to write a query which has to pull data from a remote mysql
server, modify the table scheme, format some of the fields and then
populate the new database.
i am using MySQLdb which is a python interface to mysql db.
how would i write a query to do this update from from a single
hi martin,
On Fri, Apr 23, 2010 at 9:50 PM, Martin Gainty mgai...@hotmail.com wrote:
Norm-
I would strongly suggest locking the table before updating..a SELECT for
UPDATE would accomplish that objective:
thanks for the reply and the advise on locking the table
SELECT oppc_id, limitedDate
try http://www.appsolute.nl/heraut/
you can use importerscript to run db_dump.sql from you M$ SQL Server into
dezign and then change the db type to mysql.
hth
Norman
-Original Message-
From: Stan Lester [mailto:[EMAIL PROTECTED]]
Sent: 05 January 2002 18:35
To: [EMAIL PROTECTED]
Yes it is, at $139 I think it is a supper apps, if you are not sure try the
evaluation version
-Original Message-
From: Gerald R. Jensen [mailto:[EMAIL PROTECTED]]
Sent: 06 January 2002 15:37
To: Norman Khine; Stan Lester
Cc: Mysql
Subject: Re: SQL Server 2000
You can't try http
Peter,
You can create a link to M$ Access or M$ Excel via ODBC and then use this in
your M$ Word as a MailMerge data source.
There is no option in Word to use an ODBC data source.
HTH
Norman
-Original Message-
From: Peter Reck [mailto:[EMAIL PROTECTED]]
Sent: 29 December 2001 09:56
Hello Josep
Your command seems to be wrong in accessing the db
$mysql -u jupshoes -p phpbook
Password:
What you actually are doing is trying to access the jupshoes database;^)
which infact is your password.
HTH
Norman
-Original Message-
From: josep [EMAIL PROTECTED]
To: [EMAIL
Hi Chris,
Welcome to the MySQL list;^) good to see you here...
Any way I found a link which might explain why your InnoDB inserts take
longer, perhaps this may be the reason...
http://www.mysql.com/doc/S/E/SEC418.html
In inserts InnoDB uses the insert buffer to merge secondary index records
to
Hi try http://www.devshed.com/Server_Side/PHP/SoothinglySeamless/page1.html
for good tutorials on PHP and MySQL, although biased toward Unix, I suppose
it should work in a similar way on IIS. Maybe wrong?!
snip
?
$dbuser = 'root';
$dbhost = 'localhost';
$dbpass
mysql -u username -p -h newdbname dbname.sql
-Original Message-
From: ROGGER ALEXIS VASQUEZ MARTINEZ [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 29, 2001 3:51 PM
To: Tyler Longren; ROGGER ALEXIS VASQUEZ MARTINEZ; [EMAIL PROTECTED]
Subject: RESTORE ??? RE: NewBie Question;
Hi,
The problem here is that you need to specify a user for this database, try
doing this on your server
%mysql -u root -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 19 to server version: 3.22.32
Type 'help' for help.
mysql
try http://www.devshed.com/Server_Side/PHP/DB_Basics/page1.html
why use php only try out http://www.zope.org and http://www.python.org.
MySQL interfaces with all of these, pretty well.
hth good luck
Norman
-Original Message-
From: Webmaster [mailto:[EMAIL PROTECTED]]
Sent:
Hello,
I have a database of about 40K members, which I want to port to MySQL. This
is not the problem, my problem is that I have the following table:
CREATE TABLE Person (
PersonID int(11) NOT NULL auto_increment,
Title varchar(10) default NULL,
FirstName varchar(35) NOT NULL default '',
I think you are mistaken, you do not connect the Apache you connect your
script ie php, perl, python to talk to your remote database, by specifying
the dns database and password in your config file which should be on your
apache server.
You must ensure you have the specific odbc modules
You can use a pretty cool software from http://www.datanamic.com/
First one being ImporterScript
http://www.datanamic.com/importerscripts/index.html then dump your
datastructure from your m$sql7 into Dezign
http://www.datanamic.com/dezign/index.html then use this to change the
database to MySQL.
if you have it, install phpMyAdmin it is a cool application, and quite easy
to configure, then dump the table structure.
hth
norman
-Original Message-
From: Dexter Coelho [mailto:[EMAIL PROTECTED]]
Sent: Monday, October 22, 2001 2:56 PM
To: [EMAIL PROTECTED]
Subject: How to copy
28 matches
Mail list logo