I am trying to import a few large SQL files into MySql using MyPHPAdmin. Of course this is not successful because it says that the file size limit is Max: 32,768 KiB. A found a suggestion whi...
Hi,
This was all supposed to be so simple...
I downloaded MySql 5.1, installed it very late at night, must have typed my normal password in wrong and now cant get in, struggled a lot, ...
I have a mysql database file I need to edit. It's for a Zen Cart database. The original file, before I altered it, is listed as the First Code in the included code block.
I ran am addition...
I am using a stored procedure on MySQL 5.0, accessing it via PhpMyAdmin 3.2.1
The code below works beautifully using the mySQL command-line tool. But via phpMyAdmin, I get the error below....
I have an existing ibdata file and log files in my d:\data directory and have recently reinstalled WAMP server in c:\wamp. MySQL won't start. I've included my my.ini file here. It seems as t...
I've been playing with this for a while now and can't seem to figure it out... Basically, I'm trying to return results for the first week of the month, but only for the 1st day through whatev...
I have an insert query or rather a few hundred of them (one below) that insert values into one table called links. I need to get the identity of the inserted value for each record and then ins...
I have set up two systems with mysql to support Snort with no problem , and in setting up a third I keep getting the "ERROR 1372 (HY000): Password hash should be a 41-digit hexadecimal number"...
Is there a way to find a string through the whole database?
I'm trying to output JSON format from a MS SQL procedure. The SP attached works fine as long as the @XMLString does not exceed VARCHAR(MAX)), but gives an error if this is exceeded. How can I...
I have a fresh MySQL install on Ubuntu, and can access it through phpMyAdmin, but I can't connect to it with MySQL connector or EMS SQL Management Studio from a remote XP box. I get the error...
I can't see where I'm messing up the syntax. Please see the code snippet.
I'm running MySQL 5.1 on Windows. I think I'm following this: http://dev.mysql.com/doc/refman/5.1/en/declare-loca...
Tonight I found the need to look up stored procedures for the first time. I've been having difficulty selecting a value from a table column and storing it into a variable. The procedure below ...
I am calling MySQL procedures from php (modifying phpBB). I am getting the 'Commands out of sync' error message. I understand that this is to do with the support for multiple recordsets bein...
Today I've installed LAMP on Ubuntu. At the beginning everything worked fine,today I've restarted my computer and this error came up :
Can't connect to local MySQLserver through socket/var/...
I have installed mysql-connector-net along with C# express 2008. When i want to add a MySQL data source to the code i go to "Add Data Source" but mySQL data source is not shown as an option. ...
I am in the process of setting up a Moodle server, and I have managed to screw up the installation of MySQL.
The environment is as follows:
CentOS 5.3
Apache 2.2
PHP 5.3
MySQL 5.1
...
Is it possible to compare a global C# variable in a MySQL query?
hi Experts, i have 2 mysql table and i want to add auto generated value in 2nd table from 1st but it return 0 not exact value i.e. if 8 is auto genrated value from 1st table but 0 inserted...
My site was running fine but this morning, I published an article of great interest to my readers and found that the connections to the database were a lot more than normal.
I had to stop a...
Ok I am trying to figure out how to copy a char string in the wrong format to a timestamp column on the same row so my queries will be faster. Unless there is a way to change the default form...
Hi folks!
I have server, that just had to be reloaded.
So obviously nightmare of encoding started again.
When I connect to database i execute These:
$sql = 'set names utf8; ';
$sq...
How can I kill sleeping connections to MySQL 5.1? Obviously the application code needs to close the connection, but on a server level how can I ensure that sleeping connections are kept to a ...
Dear Sirs,
I'm trying replication between two servers on mysql. Both OS is ubuntu, machines are same subnet. I used some documents for to do. When i change some records replication is workin...
mysql cause high load can any one help to optimaze mysql server please
this information about my server :
1- dedicated server only 1 site hosted on it
2- server specs :
CPU : Dual ...
