Tag Info

New answers tagged

1

Based on the suggestion I gave in the chat room, here is my answer CREATE TABLE cash_op LIKE cash_operation; Goto the datadir in your Windows server rename cash_op.MYD cash_op.MYX copy cash_operation.MYD cash_op.MYD login to mysql and run REPAIR TABLE cash_op; ALTER TABLE cash_operation RENAME cash_op_old; ALTER TABLE cash_op RENAME cash_operation; Go ...


0

What i did is : i used existing my.cnf file and copy it in another location and edit some part of it : 1. Commented #port=3306 2. Added these lines at the end. [mysqld1] basedir ="C:\Program Files (x86)\MySQL\MySQL Server 5.6" port = 3307 enable-named-pipe socket = ...


2

In Windows, you would need to modify the my.ini file and not the my.cnf file Locate you my.ini file If MySQL is being run as a service Enter "services.msc" on the Start menu search box. Find MySQL service under Name column, for example, MySQL56. Right click on MySQL service, and select Properties menu. Look for "Path To Executable" under General tab, and ...


0

You could achieve this with following steps then Installation of new instance on some new port with latest version. Swap the data directory and swap port in config file. Run mysqlupgrade. Verify the new installation. To be on safer side you may take old database backup(folder copy or mysqldump or mysqlenterprisebackup before the activity etc) Hope it ...


0

Actually, this plan is kind of dangerous for the mysql schema. Why ? You are upgrading two versions up. mysql_upgrade will not respond well to this. I have a post where someone upgraded without addressing mysql.user : Any known issues upgrading from MySQL 5.1.73 to 5.6.21? I have old posts on how to upgrade two versions in one shot Apr 11, 2013 : MySQL ...


0

disable bit-locker from the drive which has .mdf,.ldf,.ndf files. Give permission to those files ie right click-> security -> add -> full permission(read,write,exec,etc.) for that system . I hope you will be get rid of your problem.



Top 50 recent answers are included