Tag Info

New answers tagged

0

You can force case sensitivity with lower_case_table_names Add this to your my.ini [mysqld] lower_case_table_names=0 Since lower_case_table_names is not dynamic, you must then restart mysql as Administrator with C:\> net stop mysql C:\> net start mysql The MySQL Documentation says the following You should not set this variable to 0 if you ...


1

Microsoft has a MSDN document that explains how to start the SQL service in single user mode that will allow you to connect as part of the sysadmin built in role to add users back in. https://msdn.microsoft.com/en-us/library/dd207004(v=sql.100).aspx The 2008 version doesn't have as much detail as the 2014 version but you should be able to use reference ...


1

You can try below alternatives: If you installed SQL Server then you will be having "sa" - if mixed mode authentication is enabled. You can use "sa" account to create a login and map that login to a database. Alternatively, you can use "DAC" (if you have enabled it as a part of post installation step). By default, BUILTIN\Administrators has access to sql ...


0

Before doing any attempts for recovery make sure to have backup of data files. " tried to move the entire data dir." make sure my.ini has correct paths. Look at error that points at innodb_data_file_path. Do confirm your ibdata file(s) are at right location.


1

Since this is Windows we are dealing with, either use the double backslash LOAD DATA LOCAL INFILE 'C:\\Users\\userName\\Downloads\\tableName.csv' INTO TABLE tableName FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' or the forward slash LOAD DATA LOCAL INFILE 'C:/Users/userName/Downloads/tableName.csv' INTO TABLE tableName FIELDS TERMINATED BY ',' ...


1

That error is nonsequiter with regards to MySQL. This would especially be true if your Windows server crashed for reasons other than MySQL. There are ways to fix IRQL_NOT_LESS_OR_EQUAL. However, if you are reloading a mysqldump and it is the only reason Windows crashes, you may have to accommodate Windows until you fix the IRQL_NOT_LESS_OR_EQUAL error by ...


3

If you are really sure that your Server name is correct you can still try to specify the port explicitly like that: sqlcmd -S SQLMAIN,1433 -i rdmdb.sql If you run your SQL Server database as a Contained Database it might be necessary to login to the database direclty using -d: sqlcmd -S SQLMAIN,1433 -d yourDatabase -i rdmdb.sql Make sure that you ...


0

Ugliest paste in history. Be aware if your slave does not have significantly more hardware than you M1 and M2 it will probably lag behind in replication. This requires nothing special from setting up normal replication. Copy the M1 data (either mysqldump or some other suitable solution) to the first instance, login into the first slave instance and execute a ...



Top 50 recent answers are included