I am getting this error on my Domain Controllers. The SQL service is running on a Cluster of 2003 Server. Originally I found that on one node of the cluster the service was running as the do...
I am trying to replicate data from a master server to a slave. I have two servers running Windows 2003 with MySQL 5.0.
Master Server: test2k3-2
Slave Server : test2k3-1
When trying to ...
Below is (as simple as I could from a massive data import) a table and one insertion of a record. The problem is that the value going into value1 of 16.7 is getting converted to 9.9
Now, l...
I have this query:
SELECT timediff(stop_time,start_time) as total from `work`;
which gives me this
239:53:36
where 239 is hours, 53 is minutes and 36 is seconds.
Instead, I want i...
hi all,
I've changed xampp permission for phpmyadmin folder on linux fedora core 6 to
chmod -R 777 /opt/lampp/phpmyadmin/
then when prowsing I get this error on browsing
http://localhos...
I ran a mysql -V in Linux to see what version of mysql is on my server.
What version is this:
"mysql Ver 14.7 Distrib 4.1.21, for portbld-freebsd6.0 (i386) using 5.0"
I am very conf...
I'm getting the following error message when I run the query below.
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
First, I'm...
I'm getting the following error:
ERROR 126 (HY000): Incorrect key file for table '/tmp/#sql_99d_1.MYI'; try to repair it
when running this SQL statement:
UPDATE `temp0_history` INNER JOIN...
Hello All,
I am programming in java and i am trying to create a pivot table which I will explain bellow! Note I don't want the java code, I already have managed a very fragile implementati...
I can not make access remote connetion to mysql.
I have IP adress (xx.xx.xx.xx) and my domain is (www.domain.com)
database name =database_name
user id=user_id
psw=password
pls tell me h...
Hi
I've read that setting the innodb_buffer_pool_size as large as possible will help with my database which is running slow due to its large size. Please can you tell me what percentage of ...
I need a command to make just one table dump and then restore it. AND, I need the restored table to be renamed (which I can figure out, but it would be appreciated as part of this answer). Aga...
I would like to know the command to clear the screen at mysql > prompt.Thanks in advance.
Hello
I don't have much experience in mysql but i was wondering what would be the easiest way to move our current mysql database to another server. In MS-SQL Server there is a feature to a...
I've installed WAMP Server 2.0 onto my Windows XP SP2 system and I'm trying to import a mySQL database that was downloaded from the online server using Cpanel's database backup utility. The f...
Hi
I got loads of mysql-bin.0000xx files in /usr/local/mysql/var is it safe to delete those files ?
Thanks
I am trying to make an ODBC connection from Windows 2000 to my Linux Server which has MySQL server installed and running. I am able to ping the Linux connection no problem. In the ODBC admin...
I'm working on some statistical queries that I need to run against a single table with about 3 million records. I'm having some issues optimizing one query in particular, and while running EX...
I am new at this & is looking for a csv file upload script using php. The file before being uploaded need to go through some validation (eg, file type & check the various column for integer & ...
Due to failure of one of our server, we were forced to move our MySQL database from Windows, to another, linux server. Problem is, that some of our software cannot work properly now due to cas...
Hi,
Is there a function on mysql 5 we can use to encrypt a column? this column contains the passwrods.
Please kindly assist on how can we encrypt and decrypt?
Thanks.
I have a table 'kws' in MySQL database:
id BIGINT(20) kw VARCHAR(255) terms VARCHAR(2048)
where id is the primary key
I need to find the number of rows in which the word contai...
Hello expert,
I have written a stored procedure
In that i have used dynamic sql
the procedure call executes well in the sqlyog.
But when calling the procedure from the PHP it gives me er...
Can you create a user and grant privileges using CREATE USER and GRANT in a stored procedure using variables from a web page? I have code in my stored procedure to insert into the USER and DB ...
I'm installing MySQL 5.0.7 on my linux server, and followed the instructions exactly as they are in the MySQL documentation. I installed the server and client RPMs. However, I am getting acc...
