Tag Info

New answers tagged

0

I believe that what meant the author is /etc/nginx/sites-available/default, since this looks like a new server configuration and this kind of files should go there. It doesn't mean you couldn't create a file inside conf.d as well, but as per the content it looks more suitable in the path I recommend. It doesn't matter if the file doesn't exist, you can ...


3

There is nothing magical about an Amazon Linux hosted on EC2 instance. The reason everyone uses some variant of Linux is because Linux is Linux. That said, this is how I reset MySQL root passwords on Ubuntu servers if I run into trouble like this. The overall concepts should work for any version of Linux with just small tweaks to handle specifics. First, ...


1

Inspecting the output from running mysqld_safe, it kindly indicates that it's logging to /var/log/mysqld. The notable part it says: 150830 6:32:18 [ERROR] /usr/libexec/mysqld: File '/home/ec2-user/mysql-init' not found (Errcode: 2) Turns out that root can't access that location. Moved the file to /tmp/mysql-init and then the password reset worked.


0

I solved the problem following the answer from this post: Can't reset MySQL (MariaDB) root password One has to change the plugin field of mysql.user for all roots to a blank string.


0

Navicat for MySQL allows you to do this - although I think it just changes the way Navicat displays the tables, not the underlying database at all.


0

I use SQLyog to export the database as it not only allows to export in .zip file, but also gives an option to save all the objects in a single file or save individual objects in separate files. It also allows to export either only the "structure" or both the "structure and data" of the database. We can also schedule the export using windows scheduler.


0

Review your installation settings; if you selected the default to have a root password (always a good idea) then make sure you have supplied one. Don't just leave it blank.


0

You're trying to use an ODBC driver for Microsoft SQL Server, to connect to a MySQL server instance. This will never work. They just don't speak the same language! You need an ODBC driver for MySQL, like the ones from my employer.


0

You also don't necessarily need extra IP's to host more sites. http://stackoverflow.com/questions/11773544/nginx-different-domains-on-same-ip


1

You can manually put the service back as follows: STEP 01) Open the Windows CLI as Administrator STEP 02) cd C:\Program Files (x86)\MySQL\MySQL 5.6\bin or wherever mysqld.exe resides STEP 03) Reinstall the service mysqld --install That's it. I have mentioned this before in ServerFault and DBA StackExchange GIVE IT A TRY !!!


0

When you say the most recent date it means you want only one record Hostname.You can go with row number analytical function. select sum(myvalue),hostname select hostname,date,myvalue,row_number() over (partition by hostname order by date) as n from table ) where n=1 If still you d'nt get an answer .Could you please explain your requirement


0

I think you can use a query like this: SELECT SUM(My_Value) FROM Table1 t WHERE t.`Date` = ( SELECT Max(ti.`Date`) FROM Table1 ti WHERE t.`HostName` = ti.`HostName`); [SQL Fiddle Demo]


0

You can try use this query: select TABLE_SCHEMA, TABLE_NAME, (DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024 AS SIZE from information_schema.TABLES but you notice this SIZE is less than sum of *.ibd and *.frm file on disk. This is because when you delete row from table data doesn't deleted from file. To clean *.ibd file you must run query: optimize ...



Top 50 recent answers are included