Backing up MySQL using file system snapshots
http://forge.mysql.com/wiki/Backing_up_MySQL_using_file_system_snapshots
This Thursday (February 26th, 14:00 UTC), Lenz Grimmer will give a MySQL
University session on Backing up MySQL using file system snapshots. Lenz
is a member of the MySQL
What RAID level to use, whether to use SCSI or SATA etc are all pretty
much how long is a piece of string? questions. If you have a really
high end hardware array RAID 5 may be faster than RAID1+0 is on a
cheaper system.
Basically
RAID 5 = slower
SATA = slower
RAID 1+0 = faster
SCSI =
I think this is a tough one... and way above my head:
PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO.
Having a bit of a rough time figuring out how to formulate php-mysql to insert
data into fields using a multiple dropdown box in a form.
to post I am using the following:
-Original Message-
From: PJ [mailto:af.gour...@videotron.ca]
Sent: Sunday, February 22, 2009 2:39 PM
To: MySql
Subject: book categories
Here's a tough one...
In my library I have some 62 categories where a number of books can be
in several categories.
Now, to relate the categories
Hi,
It will never work this way. MySQL has no knowledge of the php variable
$categoriesIN
you can try something like this:
?
$sql4=INSERT INTO temp (example) values ;
for( $ii = 0 ; $ii count($categoriesIN) ; $ii++ ){
if($ii)$sql4.=,;
$sql4.=( .$categoriesIN[$ii].);
}
$result4 =
PJ wrote:
I think this is a tough one... and way above my head:
PLEASE READ ALL OF THE ABOVE TO UNDERSTAND WHAT I AM TRYING TO DO.
Having a bit of a rough time figuring out how to formulate php-mysql to insert
data into fields using a multiple dropdown box in a form.
to post I am using the
It's actually a very simple solution, and you should do it all in a
single INSERT. Putting INSERTs in a loop will kill your performance
when you try to scale.
$sql4 = 'INSERT INTO temp (example) VALUES (' . implode('),(',
$_POST[categoriesIN]) . ')';
$result4 = mysql_query($sql4, $db);
That
I have a number of duplicate records in my table which are identical hence,
I can't do a delete on the columns without deleting both records. One
deletion strategy I have considered is identifying the records by their
table record id - but I don't know for certain that such an identifier
exists or
2009/2/23 Hagen Finley finha...@comcast.net:
I have a number of duplicate records in my table which are identical hence,
I can't do a delete on the columns without deleting both records. One
deletion strategy I have considered is identifying the records by their
table record id - but I don't
You're looking for something like:
This gets called 10 times from another function, but this is sort of
what you're looking for. This gives me a combo-box.
function qselect($mysql_link, $i)
{
$driverquery = select car_no, drv_name from cars order by car_no
+ 0;
$driverresult =
On Mon, Feb 23, 2009 at 11:40 AM, Hagen Finley finha...@comcast.net wrote:
I have a number of duplicate records in my table which are identical hence,
I can't do a delete on the columns without deleting both records. One
deletion strategy I have considered is identifying the records by their
SCSI isn't necessarily faster now. The big difference used to be
SCSI's support for command queueing, which is why it was faster in
multi-user environments. Command queueing is now fairly common in SATA
drives.
The highest end SCSI is probably still faster than the highest end
SATA, but you will
Here's my test page and, so far, nothing works...
?
session_start();// Include sessions_start() in everything
include (db1.php);
$thisInterface = addNewBooks;
if (!isset($_SESSION[addNewBooks])) {
$categoriesIN= ;
// Save the input variables in session variables
-Original Message-
From: Hagen Finley [mailto:finha...@comcast.net]
Sent: Monday, February 23, 2009 11:41 AM
To: 'MySql'
Subject: Record IDs
I have a number of duplicate records in my table which are identical
hence,
I can't do a delete on the columns without deleting both records. One
Brent Baisley wrote:
It's actually a very simple solution, and you should do it all in a
single INSERT. Putting INSERTs in a loop will kill your performance
when you try to scale.
$sql4 = 'INSERT INTO test (example) VALUES (' . implode('),(',
$_POST[categoriesIN]) . ')';
$result4 =
hi,
I've been using mysql-5.1.22 in my project, which processes a lot of
read operations but little write operations. I got the idea from some
of my coworkers that binlog has a chance to be corrputed so that
mysqlbinlog can't process it correctly.
Is there any usable plain text SQL log in
16 matches
Mail list logo