Hi,
I'm a novice to MySQL and am currently facing the following difficulty.
I'm trying to update a table with a row of data the primary key of which is
an ID which I believe is an auto incrementing serial number. My first
question is how to check if this is the case.
Hi Toni
from the
Hi Folks,
I'm in need to connect from my SQL 2008R2 (64 bit) server, to my MySQL
database server...
I found this page:
http://www.mysql.com/downloads/connector/net/
This page has the 32 bit drivers, but I *believe* I would need 64 bit,
since it's being installed on the 64 bit SQL server,
You can extract table names and all the fields use linux command *SED*.
http://www.cyberciti.biz/faq/sed-display-text/
sometime I used sed command to extract single database from multiple
databases dump file.
using sed to extract single database from the dumpfile:
Hi,
In my MySQL directory, I have more than a few gig and a half sized files,
mysql-bin.01, mysql-bin.01 and et cetera. They date from today all the
way back to early 2010. I don't know exactly what those files are but I would
like to delete as many as are no longer is use since I
Am 14.11.2011 19:01, schrieb Rob Tanner:
In my MySQL directory, I have more than a few gig and a half sized files,
mysql-bin.01,
mysql-bin.01 and et cetera. They date from today all the way back to
early 2010.
I don't know exactly what those files are but I would like to
Those are your binary logs. They store the data stream to be consumed
by your slaves.
.http://dev.mysql.com/doc/refman/5.0/en/binary-log.html
Are you using replication? If so, you need to go to each of your
slaves and run the command 'SHOW MASTER STATUS;'. That will tell you
which files are
If you search on mysql-bin.01 you get a lot of good info.
o They are mysql log files it contains all the queries u can view
these files with the command mysqlbinlog just man it for more details
o These are your binary log files.. you might not want to switch them
off depending on your setup -
The binary log is useful for more then just replication and can be used to
take incremental backups or to perform forensics on what your server has
done. I would recommend learning how to use them to your advantage over
turning binary logging off as some have recommended. Make sure you're
David
Afaik, the connector is pure .net application, so there is no 32/64 bits
distinction; you can use it in either architectures.
Carlos
On Mon, Nov 14, 2011 at 9:23 AM, David Stoltz dsto...@shh.org wrote:
Hi Folks,
I'm in need to connect from my SQL 2008R2 (64 bit) server, to my MySQL