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 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.
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.