random1

Hi MySQL Gurus, I'm wondering if someone knows how to prevent mysqldump from adding new lines in stored procedures upon each database dump (backup). Alternatively a way of "removing all new lines from all stored procedure bodies in a database" as an SQL command would be awesome.

Thanks I ended up doing the following... 1) Stop MySQL Service 2) Initialize default mysql database ("data" folder) using command line mysqld.exe --initialize --user=mysql 3) Run (start) MySQL with passwords disabled mysqld.exe -u mysql --skip-grant-tables 4) Manually edit `mysql`.`user` table passwords

I'm trying to fresh install the latest version of MySQL manually. When I download it from mysql.com I get the file "mysql-5.7.9-winx64.zip", but unlike previous versions it has no "data" folder and a near empty "my.ini" file. Could someone more learned let me know what is going on with this?

The aim is to make my.cnf generic so that it can be more easily deployed to other network environments. I'm also trying to avoid creating a "generator" script that creates my.cnf.

Hmm... I've worked out the syntax: ${VARIABLE} but it only partially works. :S

I've worked out that Enviroment Variables can be reffered to using the syntax: ${VARIABLE}

Thanks for the reply. I got it working by creating a .CMD file for creating the Windows Environment Variables (only Windows 7 or later): SETX DEV_SERVER_DIR D:\webserver /M SETX DEV_SERVER_APACHE_DIR D:\webserver\apache /M SETX DEV_SERVER_PHP_DIR D:\webserver\apache /M SETX DEV_SERVER_MYSQL_DIR "D:\webserver\mysql\MySQL Server 5.6" /M SETX DEV_SERVER_MYSQL_DATA_DIR "D:\webserver\mysql\MySQL Server 5.6\data" /M pause and then in PHP.ini, for example: [PHP] include_path = ".;${DEV_SERVER_APACHE_DIR}\htdocs" and start the Apache Windows Service and check the variable with phpinfo. thanks!

I'm running the latest stable version of PHP in Apache Server on Windows 7 64-bit. It working fine and set up correctly. I'd like to use ENVIRONMENT VARIABLES or a variable like "%current_directory%" or "..\%current_directory%" in the configuration files for PHP, php.ini. Is this possible? Is php.ini a parsed file, can variables be define and used in it? Help would be much appreciated

I'm running the latest version of MySQL on Windows 7 64-bit. It working fine and set up correctly. I'd like to use ENVIRONMENT VARIABLES or a variable like "%current_directory%" or "..\%current_directory%" in the configuration files for MySQL, my.ini. Is this possible? Is my.ini a parsed file, can variables be define and used in it? Help would be much appreciated

I'm running the latest version of Apache Server on Windows 7 64-bit. It working fine and set up correctly. I'd like to use ENVIRONMENT VARIABLES or a variable like "%current_directory%" or "..\%current_directory%" in the configuration files for Apache, httpd.conf etc. Is this possible? Is httpd.conf a parsed file, can variables be define and used in it? Help would be much appreciated

preferably XML format but if the above is simply a JSON formatted response I'll check out using json_decode.

Hey All, I am using a web service and am getting the response formatted like: http://pastebin.com/raw.php?i=AjDXXf66 e.g. [[["test","test","",""]],[["noun",["test","essai","épreuve","examen","contrôle","analyse","interrogation","épreuve pratique","épreuve de force"],[["test",["test"],,0.23752081],["essai",["test","trial","testing","essay","assay","try"],,0.12913783],["épreuve",["test","proof","trial","examination","print","crucible"],,0.028814545],["examen",["review","examination","test","investigation","inspection","testing"],,0.010767208] ... ... ... To my knowledge it is some kind of expression of a multidimentional array however I've never seen a response like this. Is there a way I can convert this format to clean XML?

Update: After more work and research I have the code: @-webkit-keyframes FadeIn { 0% { opacity:0; } 100% { opacity:1; } } @-webkit-keyframes FadeOut { 0% { opacity:1; } 100% { opacity:0; } } @-moz-keyframes FadeIn { from { opacity:0; } to { opacity:1; } } @-moz-keyframes FadeOut { from { opacity:1; } to { opacity:0; } } @-o-keyframes FadeIn { from { opacity:0; } to { opacity:1; } } @-o-keyframes FadeOut { from { opacity:1; } to { opacity:0; } } @keyframes FadeIn { from { opacity:0; } to { opacity:1; } } @keyframes FadeOut { from { opacity:1; } to { opacity:0; } } #example { -webkit-animation:FadeIn ease-in 0.5s; -moz-animation:FadeIn ease-in 0.5s; -o-animation:FadeIn ease-in 0.5s; animation:FadeIn ease-in 0.5s; -webkit-animation-fill-mode:forwards; -moz-animation-fill-mode:forwards; -o-animation-fill-mode:forwards; animation-fill-mode:forwards; } and its working all but Internet Explorer. Any advice?

I'm trying to fade in a div using CSS3 only. The CSS code I currently have written is: @-webkit-keyframes FadeIn { 0% { opacity:0; } 100% { opacity:1; } } #example { -webkit-animation-name:FadeIn; -webkit-animation-timing-function:ease-in; -webkit-animation-duration:2s; } This fades works in Google Chrome but not in Firefox, Internet Explorer or Opera (as I expect). How can expand on this code using CSS3 code to support Firefox, Internet Explorer and Opera etc?

Hey All, The following runs fine: CREATE DEFINER=`root`@`localhost` PROCEDURE `procedure_admin_reset_autoincrement`(IN `tableName` VARCHAR(100), IN `incrementInteger` INT) LANGUAGE SQL DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER COMMENT 'Resets the AUTO_INCREMENT value for a table' BEGIN ALTER TABLE tableName AUTO_INCREMENT = 1; END But when I try changing "= 1" to "= incrementInteger" it fails: Am I missing something really obvious? :S :B Is an auto_increment value strongly typed?

I have been developing a database in MySQL using the InnoDB starge engine. I'm trying to iron out slow performing queries I have in my database. My Slow Query Log contains: # Time: 120716 22:27:51 # User@Host: MYUSERNAME[MYUSERNAME] @ localhost [127.0.0.1] # Query_time: 0.002929 Lock_time: 0.002929 Rows_sent: 21 Rows_examined: 21 use webman; SET timestamp=1342441671; SELECT `language_string_id`, `language_string_name`,`language_string_text` FROM `language_korean` ORDER BY `language_string_id`; # User@Host: MYUSERNAME[MYUSERNAME] @ localhost [127.0.0.1] # Query_time: 0.002929 Lock_time: 0.002929 Rows_sent: 19 Rows_examined: 47 SET timestamp=1342441671; SELECT * FROM `view_language_list`; # User@Host: MYUSERNAME[MYUSERNAME] @ localhost [127.0.0.1] # Query_time: 0.000000 Lock_time: 0.000000 Rows_sent: 21 Rows_examined: 21 SET timestamp=1342441671; Both Queries: 1) SELECT `language_string_id`, `language_string_name`,`language_string_text` FROM `language_korean` ORDER BY `language_string_id`; 2) SELECT `language_wms`.`language_id` AS `language_id`,`language_wms`.`language_name` AS `language_name`,`language_wms`.`language_description` AS `language_description`,`language_wms`.`language_text_direction` AS `language_text_direction` from `language_wms` where `language_wms`.`language_status_id` order by `language_wms`.`language_ordering`,`language_wms`.`language_name` I ran EXPLAIN on them and got: 1) id;select_type;table;type;possible_keys;key;key_len;ref;rows;Extra 1;SIMPLE;language_korean;index;;PRIMARY;8;;21; 2) id;select_type;table;type;possible_keys;key;key_len;ref;rows;Extra 1;SIMPLE;language_wms;ALL;;;;;28;Using where; Using filesort Is there a way to speed up these queries and get them out of appearing in the slow query log?

As per: http://www.queness.com/post/11156/speed-up-web-page-loading-by-deferring-javascript Does deferring JavaScript mean that it cannot be cached locally and needs to be fetched each time a page request is made? I've be not able to set the return as 402, Not Modified, like the rest of my CSS, JPG, PNG files.

Part of my my.ini file is: [client] port=3306 collation_connection=utf8_unicode_ci default-character-set=utf8 [mysql] collation_connection=utf8_unicode_ci collation_database=utf8_unicode_ci default-character-set=utf8 [mysqld] port=3306 basedir="C:/webserver/mysql/" datadir="C:/ProgramData/MySQL/MySQL Server 5.5/Data/" user=mysql collation_server=utf8_unicode_ci character-set-server=utf8 init_connect='SET collation_connection = utf8_unicode_ci; SET NAMES utf8;' skip-character-set-client-handshake However when I check the server when running collation_connection = utf8_general_ci. Any ideas what I'm missing here? How can I set this value globally? BTW I'm running MySQL Server 5.5. Reference: http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_collation_connection

The books that got really into PHP and MySQL were: - Wicked Cool PHP - PHP Phrasebook - MySQL Phrasebook Highly recommended :D Also get used to searching google.