 | | | MySQL General | | Does anyone have a list of the files that need to be backed up for a
cold backup of an innodb database
Obviously all the MyISAM files and the innodb database files. But what
about the log andHi
is that possible to use a result of a calculation as a field? for example
SELECT num1 + num2 AS var1 IF(var1 > 100 'Good ' 'Bad ') FROM table1
--
MySQL General Mailing List
For lisHi!
jeffrey_n_Dyke@(protected) wrote
>
>
> I have just installed MySQL server v3.23.49-8.5 (downloaded from Debian
> Packages Site) into my Debian v3.0r2 box! After finished installing i had
>Hello
I keep getting this error when attempting to utilize a database that has Innodb
tables and using transactions. This is from a Perl/DBI script too
Error
Transactions not supported byOn Tuesday 30 March 2004 10 53 am Matt Chatterley wrote
> Hi all
hello.
<snip >
> In-between lamenting the lack of views one of the things I most miss from
> SQL Server and which I need Hello
i try to store some files into a blob-fields of a myisam-table at mysql 4.1.
If the file includes bytes with hex-value 00 mysql will only store the bytes before this ' 0-byte ' .
How can On Tue Mar 30 2004 at 10 30 03AM -0800 Dathan Vance Pattishall wrote
> Tips on managing very large tables for myISAM
>
> 1) Ensure that the table type is not DYNAMIC but Fixed.
> > Issue Hi Mike
> I 've downloaded and installed 5.0 it seems to be working fine. However I
> need a graphical user interface to create tables and such (when I say I
> need trust me I need). I 'm I 'm having some problems with this function. I have a "conn.inc " file that
each of my web pages accesses to create the connection to my database and
I 'm trying to use the mysql_init() function but I am having problems with the number of simultaneous connections in the
MySQL. I configured 5000 connections but when arriving in 4096 it
presents the errors below.
MySQL Connection Failed Can 't In a bit of a quandary here...
I have a user table and a registered serials table
Table data at end of email...
I have been given a large set of new data but it is flat file basically
it loMySQL users
I have one table in a database which will not allow me to edit
it in phpMyAdmin. Every time I try to select the row for editing I get
an error which says "tbl_row_delete.php MissingHI
the ibdata1file in mysql\data has reached a size of 10Mb in just over a
week the database I have set up is quite limited only 7 tables with no
more than 12 records in any one table (only eHi
My MySQL server is running on a 2-cpu machine with SMP RedHat 9.0. Currently I 'm
executing a lot of small INSERT-queries on it. My client program is single-threaded
using the basic mysql-APd r wrote
>I am a personal user who just downloaded the version
>4.0 and
>mysql
>
>
> > administrator. The first time I clicked on the
> > "Administrator " icon
> > on my desktop I getHi Scott
> Is there any way to define a column in MySql 4 that is to be unique from
> this point forward. Meaning there are indeed dupes in the column now
> those are ok there is really noHi
I asked yesterday about how to get swedish vocals (???)when using *load
data local infile "file.txt " into table* syntax.
The file.txt is written with swedish vocals and saved in unicode format Scott Haneda <lists@(protected) > wrote
> I currently run this which is 2 hits to the database.
>
> Select serial from blacklist where serial '23 '
> Select serial from seriallist where serial Jonas Lind?n <jonas.linden@(protected) > wrote
>
> Is it possible to grant access to individual rows in a table in MySQL?
No MySQL doesn 't support row level grants. In general you can use VIEWOn Mon Mar 29 2004 at 08 44 28PM -0800 Gene H. Dreher wrote
>I seem to have locked myself out of my database. RH8/4.0.18-standard
>... the key user does not have file/reload/etc access. and nohi
msvcr70.dll is part of the Microsoft(r) C Runtime Library v7.
You can download this file free of charge from
http //www.dll-files.com/cgi-bin/cgiwrap/dll-files/topdown/download.pl?file msvPersonally it 's an unexpected flaw that I hope one day will be fixed. But
I 'm not holding my breath even though they seem to be planning for it. But
it could also be because of query-cache.
TChris
You would have to send the table structures including any indexes and also
the real queries.
It would also help if you would send an explain on your select statements.
100+ a minute is
Dear Friends
then in compiling MyODBC (3.51.06)...
Making all in samples
make[1] Entering directory `/storage/MySQL/src/MyODBC-3.51.06/samples '
source 'my_basics.c ' object 'my_baIs it possible to query a tmp table that mysql creates automatically when
dealing with large queries?
When I do a 'show processlist ' and it gives a state of 'Copying to tmp
table ' is there a waChris Petersen <lists@(protected) > wrote
> I 'm trying to set up two-way replication between our colo and our office
> (slow DSL line) so our web customers can get the fast speeds of our
> colKen Elder writes
>Today I experimented on two computers. One consistently got the error
>message the other consistently did not get the error message. Both
>computers were Win98SE with IE6.0. In article <000f01c415e0$d91f9600$0bb4aaa0@(protected) >
"Timon Berkowitz " <timon@(protected) > writes
> Hi there
> I have a hard question don 't know if its possible to solve my query.
> I haTim Cutts wrote
> On 30 Mar 2004 at 09 05 Tim Cutts wrote
>
> > SATA RAID devices aren 't that bad you know and they are a lot
> > cheaper than equivalent amounts of SCSI storage. We 've usedOn Mon Mar 29 2004 at 03 58 29PM -0500 Michael J. Pawlowsky wrote
>
> How would I do this?
>
>
> Let say I have an employee table with
>
> Name varchar(64)
> Dept int(11)
> Salary |
|
|
