MySQL Database Forum

Hi list, Does any know how to do differential backups or does exist a tool that do this kind of backups. I have mysql 4.0.12 and use innodb tables, mysql is running on redhat 7.3 Greetings and thnx in advanced

Is there a way for a user to get knowledge about his own privileges? For example can a user know if he/she has rights to INSERT INTO some = table? I'm using PHP4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmysql@freebsd.csie.nctu.edu.tw

does MYSQL have a quota built into it! I need it limit the size of each database AndiC

Good afternoon, I'm looking for information on good benchmarking implementations with which to test MySQL using multiple clients. The benchmark utilities included with MySQL are, as far as I understand, an implementation of the old Wisconsin Benchmark, and as such are designed to test only a single client sending queries to the database. ...

Hello... I'm using mysql(4.0.13) on linux. I want to create logs only for one database or for one user. Is this posible :S ?! Thaks.

I'm attempting to create a database which will take information from one (perhaps two) tables and utilize that information to return queries to a report designed in Excel. The general idea I have is this: The "primary" or "source" table is easy. This is a trial balance (account number as a primary key, description, amount). I'll need...

I'm trying to run this query: SELECT * FROM features WHERE food_group_ID = 'Company™' I've tried Company%99, Company™ Company™ and nothing returns. What do I need to pass from a jsp page to represent the trademark in MySql? Thanks

Greetings all I am not able to GRANT file permission to users. All permissions end up being issued with FILE being left out. What could I be missing? I running 3.23.53 on Mac OS 10.2. Thank you. ------------- David Scott

Here is the situation: I have one table that lists a number of courses available (including CourseID, CourseName and MaxPositions), with CourseID being auto_increment and unique I have another table which has CourseRegistration (Containing CourseID and CustomerID), with no unique fields. Customer information is stored elswhere.

This is the currernt table strucure PHP:-------------------------------------------------------------------------------- CREATE TABLE games_developers ( developers_id int(5) NOT NULL auto_increment, developers_name varchar(255) NOT NULL default ' ', language_id int(5) NOT NULL default '0', PRIMARY KEY (developers_id,language_id)

Hi! I'm currently trying to move from MS SQLServer to MySQL, running on windows XP. When trying to connect to mysql on localhost with mysql control center I get the 2013-error "Lost connection to MySQL server during query". I can connect from command line. If I do so, and change passwords by using OLD_PASSWORD('<password>'), control...

--------------Boundary-00=_O5I3QL80000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_O5I3LVC0000000000000" --------------Boundary-00=_O5I3LVC0000000000000 Content-Type: Text/Plain; charset="iso-8859-9" Content-Transfer-Encoding: quoted-printable

I have a dymanic site using PHP and MySQL. When I test it on the remote server, it works great. But when I test it from the Apache server on my development machine, whenever I try to access a .php page that accesses my MySQL database, I get: Access denied for user: 'okmpc@localhost' (Using password: YES). Can anyone please tell me what...

I'm trying to process a series of records sequentially using a routine something like this using Delphi 7/Zeos Components # retrieve result set: Query.SQL.Clear; Query.SQL.Add(' SELECT * FROM items WHERE invoice = :invoicenumber '); Query.Open; # process each record of result set WHILE (invoicenumber = item.invoice) DO

I need to have a table that supports FULLTEXT searches. This implies that this table should be a MyISAM table. However, I also require that this table act as a parent for child tables in order to support referential integrity. If I create the child tables as INNODB tables, will referential integrity still work with the MyISAM parent table?...

OK, I have a MySQL server running 4.0.12 on a 12 CPU Sun U4500 with 12GB of memory. With the query cache running, this machine would noticeably "hiccup" (just stop responding to requests) every so often and wouldn't squeeze more then 1000 queries per second or so as a result (heavily mixed OLTP work, with a lot of SELECT's and almost as...

I've got a library of PHP code whose first line is a mysql_connect statement, like this: $dbh=mysql_connect() or die("mysql connect failed: $php_errmsg"); Approximately 1% of the time it just fails, for no stated reason: Warning: mysql_connect() http://www.php.net/function.mysql-connect]: in /var/httpd/htdocs/pi/pi.php on line 3 mysql...

Folks, I'm using MySQL 3.23.56-Max and I have several CREATE TABLEs similar to the following in structure (taken from my PHP script so ignore the double quotes and periods) "ID MEDIUMINT(10) NOT NULL AUTO_INCREMENT," . "publisherHash CHAR(32) NOT NULL," . "articleHash CHAR(32) NOT NULL UNIQUE," . "issueID MEDIUMINT(10) NOT NULL," .

Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Lines: 105 Message-ID: <nlnBb.422437$0v4.20362698@bgtnsc04-news.ops.worldnet.att.net> Date: Tue, 09 Dec 2003 17:09:39 GMT NNTP-Posting-Host: 12.72.193.239 X-Complaints-To: abuse@worldnet.att.net X-Trace: bgtnsc04-news.ops.worldnet.att.net 1070989779...

Hi, I have a simple master/slave replication environment that is working smoothly with one exception. If I restart the master server the Master Log File is incremented by one (e.g. the original master log is named data-bin.000001 and the new master log is named data-bin.000002) the slave server never notices that the Master Log File and...

Does MySQL have any text compression capabilities (besides using packing)? Or do I have to use PHP to compress and uncompress the text using it's zlib functions? thx -- Robert Oschler http://www.dog-images.com -- Devoted to providing free info on the health,

I am getting relay-bin logs on my master server. They are all empty except for one line that reads: þbin I have no slave settings in my my.cnf file. Any idea where these are coming from and how to turn them off? Brian Moon dealnews.com

Hi, When installing the mysql4 binary it works fine. When installing the mysql max4 binary I get the following message when I try to run mysqld_safe. I am running linux redhat 9.1. Would anyone know why this is happening? 030728 23:54:57 mysqld started 030728 23:54:58 bdb: /usr/local/mysql/data/log.0000000001: Permission

Is there a way within MySQL to forward all Inserts/Update requests from the Slave to the Master, or much I rearchitect my application to carry two connection; one connection to the Master for updates and the other connection to the slave for Selects? TIA.

In the older version of mysql, when I pressed browse, I could see the content of the table. If I ran a query, such as select * from table, it would scroll out the result. Now, with the newer version, all it does is hang. Is there some setting I'm missing that needs to be changed? This was newly installed on our apple server. Thanks, Bill