Tag Info

New answers tagged

0

I was frustrated by this for some time, but finally found a solution. In my situation the problem was with "DELIMITER", which is a command only used by the mysql command line client. It's not part of the API, which is what the mysql gem is using. SOURCE: https://github.com/opscode-cookbooks/database/issues/75 To restore from the dump I use this function ...


0

Did you as changes to user are not noticed until you do this or login again? flush privileges;


1

If I've right understood your question, the number 19700101 is so-called Unix Time Stamp Converted it points to Mon, 17 Aug 1970 00:15:01 GMT: http://www.onlineconversion.com/unix_time.htm The unix time stamp is a way to track time as a running total of seconds. This count starts at the Unix Epoch on January 1st, 1970 at UTC. Therefore, the unix ...


0

This should work: cd /usr/local/mysql sudo bin/mysql_secure_installation As the error message Can't find a 'mysql' client in PATH or ./bin says, mysql_secure_installation is looking for a mysql client in your PATH or ./bin directory - so if you want it to find /usr/local/mysql/bin/mysql, it should be started from /usr/local/mysql.


0

The problem in the end was that mysql was only listening for connections from localhost. So to solve the problem find your my.cnf file which should be located in the /etc/ folder. To find it I used ls -l my* im not sure if this commad is correct but it found it for me anyway. Inside the file should look like this: [mysqld] #bind-address = 127.0.0.1 ...


0

you could do apt-get remove instead, and additionally remove config files in /etc/mysql. Also, apt-get might ask you if you really want to purge databases, but that depends on your distribution and version. But, to answer your question, to backup mysql, you should simply backup all files in it's database, including ib_data* files for InnoDB. Default ...


0

Go to the Windows Command Line and run the Following cd "C:\Program Files\MySQL\MySQL Server 5.0\bin" mysqld --version cd "C:\Program Files\MySQL\DBServer\bin" mysqld --version These should return something like mysqld Ver 5.5.37-log for Win64 on x86 (MySQL Community Server (GPL)) You will see which version of MySQL is which. As for C:\Program ...


0

Assuming you have optimized your query and indexed properly. you can: throw additional hardware to decrease time attempt to shorten the connection distance between the update caller and the database (assuming they are not on the same box) preempt to cache(if possible) the changing values if known beforehand


1

Use utf8 and you should be good to go. It supports more languages than you can shake a stick at. MyISAM and InnoDB both seem support it according to the MySQL docs, though I only have Postgre experience.


0

I found my self where i did mistake , here am providing my localsettings.php. if any one need it, follow this you might be succeed after creation of successful mediawiki page you will get fresh localsettings.php. in that just add the following lines. then you will get authenticate to your LDAP databse. Those who are there in LDAP database those need not ...


0

I think this is tolerably complex. It's a branch of Natural Language Programming (not the other NLP, Neuro Linguistic Pap). You need to be able to match "here" and "hear" - so you need to break down the elements, and map them to a phonetic equivalence (h-"ere" and h-"ere" for both). And some spellings have variant phonetics (cough, plough, through) or have ...


0

You can use string comparison among strings of the same length and allow for one (or two) unmatching characters. By looking at your website, though, I'd suggest to map the words by their phonetic representation and then search into them, treating the strings like characters arrays and starting the comparison from the back. To build over your example: near ...


1

The password isn't sent in plain text, but the old-style password scheme you're using has known issues that make it relatively easy to crack. See http://dev.mysql.com/doc/internals/en/authentication-method.html, and the related question http://stackoverflow.com/questions/11192689/how-secure-is-authentication-in-mysql-protocol.


0

Here is the difference: mysqld-nt.exe was a version of MySQL that took advantage of a specific Windows Communication Protocol called Named Pipes. According to the the Book Chapter 23 Pages 352,353 under the Section entitled "23.2 Communication Protocols" Bulletpoint #3 says Named-pipe conventions are supported only on Windows and only if you use one ...


0

I believe they are the same thing, the background service (aka Daemon) that is the MySQL program/interface. From my understanding the "-nt" was dropped from the Windows versions (renamed to just Mysqld.exe) sometime around version 5 of MySQL. I have no source to cite unfortunately, but our MySQL servers run 5.x on them, and none of them have a ...


2

Your / (where /var/ is appended) is full: 100%. On my rasp I'm running nginx with sqlite because apache and mysql use way more resources in general. It doesn't look like 8GB in total, according to your df output. Anyways, I guess your log files consume the diskspace. You can use the following to find the folder which uses much: du -sch /* and: du -sch ...


1

If you have LVM, create a separate partition mount in required size. you can use the --tmpdir option to mysqld. Check this. http://dev.mysql.com/doc/refman/5.0/en/temporary-files.html


1

Use the --one-database option from mysql command. mysql -u root -p --one-database your_db < full_backup.sql You first need to create a blank database same name as present in the full_backup.sql which you want to restore. For more info on --one-database refer to the documentation. ...


0

After many attempts in a virtual machine, I have decided that is too much of a risk for a production environment to force the quota on (-m). The issue only happened 1 time since I am taking care of this infrastructure and suspect it must be related to a dodgy query in the server creating a huge temp table. Thanks all for the suggestions.


-1

Thanks for your replies. Disabling SELinux solved the issue. Open /etc/sysconfig/selinux. Change the SELINUX= line to SELINUX=disabled.


0

Apache Go to http://localhost:80 on your web browser. A page saying your Apache server is running properly should show up. If this isn't working, confirm your apache service is running and restart it if necessary by running service apache2 restart. Files placed in /var/www/html should be served by the Apache server. PHP Place a php file in ...


0

Has your service provider provided you the mysql connection link which is required by your php code? if so please use it. It contains server hostname(url)/ip. Also, you can use local mysql console (client) to check connection. mysql -u username -h -p Check for error code


1

The mysqldump output format is simply a long list of SQL commands, meant to be fed back into the mysql program. You can use mysqldump --ignore-table=<database>.<table> to create a dump that does not include the access_log table at all. Then you can use mysqldump --no-data=true to dump just the structure for the access_log table. If you ...


0

You can probably try running the following SQL on your windows machine first GRANT ALL ON *.* TO 'root'@'%'


0

Don't try to touch the file. It's not up to you to do that. Your MySQL server doesn't appear to be running. How to start it depends on your Linux distribution (Debian? Gentoo? Red Hat?), but it's probably something like sudo /etc/init.d/mysql start or sudo service mysql start Then try again. It may also be the case that MySQL isn't listening on a UNIX ...


-1

I would recommend Navicat (Not free but has 30 days free trail). It is a good tool as far as visual query building is concerned. :-)


1

A little inspection would tell you the difference - right click on either link, properties and see what it says. The former is the plain vanilla command prompt. Looking at the latter, it runs a file called nodevars.bat which ensures your node.js and npm are first in path (and other things. READ IT!). That makes sure that node.js commands like npm would work ...


0

Here is most likely your problem: -A INPUT -j REJECT --reject-with icmp-host-prohibited -A INPUT -p tcp -m tcp --dport 3306 -j ACCEPT The rule ordering is wrong. iptables rules are evaluated "top to bottom" and the first rule that matches (with very few exceptions) is the final one. You have a REJECT rule preceding the ACCEPT rule, so the REJECT rule ...


0

If you've got ... when enabling your service unit, copy it to /etc/systemd/system Failed to issue method call: No such file or directory To enable your service unit, add below the ... so you can system enable mysqld.service (its enable in every user's namespace) [Install] WantedBy=multi-user.target Cheers, sugatang itlog


0

You are probably trying to start mysql.exe by double clicking on it, but what you should do is open it through the Windows Command Line or Powershell. In Windows 7 search for PowerShell and then navigate where mysql.exe is installed and through the powershell/command line call mysql.exe and start it. (Read/watch manuals/videos/tutorials) If the command line ...


1

Are you sure about it? AFAIK the temp tables are existing as long as they needed - for a query, but after they'll vanish. If you have as many active queries which needed 30GB temp tables that will cause you a lot more trouble than using all free space (I meant disk IO etc.) You can still playng with ulimit, but that'll need service restart at least, so I ...



Top 50 recent answers are included