Jump to content

random1

Members
  • Content Count

    425
  • Joined

  • Last visited

Community Reputation

0 Neutral

About random1

  • Rank
    Advanced Member

Profile Information

  • Gender
    Not Telling
  1. 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.
  2. Nullable? No.

  3. 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
  4. 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?
  5. 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.
  6. Hmm... I've worked out the syntax: ${VARIABLE} but it only partially works. :S
  7. I've worked out that Enviroment Variables can be reffered to using the syntax: ${VARIABLE}
  8. 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!
  9. I ain't no weeblewobble

  10. 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
  11. 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
  12. 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
  13. 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.
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.