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...
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 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 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 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'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 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 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 am creating a simple login page using php and MySQL. I am new at this and cannot figure out why I am getting this error:
Warning: mysql_num_rows() expects parameter 1 to be resource, null...
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...
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
...
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 ...
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...
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 have the following stored procedure that puts a website url in a table with its description and so forth and returns the last inserted id . I was wondering if someone could give me an exampl...
Hello group,
I just have installed SugarCRM on a server where I must bind it to database. I'm new to CRM and need to connect it to at least one table of the database create some reports....
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...
I'm running mysql 5 on CentOS. Sometimes (a couple times a week) mysql takes 98% CPU load and then I can't access the server anymore and have to restart it (using my provider's control panel)....
Is there a way to make a single database of my choosing read only. I have a production database and a staging database. When I place the production database in "staging mode", there will be ...
I have a database that has been configured to have dates stored in "string" format. The database is returning "2009-08-12 11:40:00" instead of the unix datetime format. I need to parse out the...
Hello,
I have a table with ID and Keywords, in keywords field words is separate by ';'. iI want split each delimited sting into rows. Some rows have 1, 2, 3 to 6 or 7 word separated by ;.
...
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...
I have a trigger that checks a value in a row and if that value is not empty, then it sets a value in another cell in the same row. When this trigger is invoked it works fine.
I have anoth...
