I have an SQL file containing two tables with around 600,000 rows altogether. Yesterday, I tried to import the file into my MySQL database on Fedora 16, and it took over 2 hours to import the file. On my Windows PC it took 7 minutes. My Linux and Windows machines have exactly the same hardware. A couple of my…
Tag: mysql
mysql_upgrade not found
I’ve just upgrade my system, but Mysql don’t start: so I am asked to run myslq_upgrade, but it’s not present on the system… Any help? Answer Finally, I had to manually remove some of the package, rename old database and configuration file, reinstall things and it worked, but still no m…
Increasing the caching capability of MySQL
My mysql only caters read requests. I thought, it will be a good idea to make use of the cache completely. I am running MySQL in a VM and that is the only application running inside the VM. I am allocating 2GB memory for that VM. I am using a 64 bit centos on the VM. If you think already
Check if mysql database exists, perform action based on result
Is it possible from within a bash script to check if a mysql database exists. Depending on the result then perform another action or terminate the script? Answer Example script (Thanks to Bill Karwin for the –user and –password comment!): These are what the commands look like when run at a prompt:…
Accessing a mysql database from external host/ip? (ie: mysql workbench)
I have a mysql server running on x.x.x.x, and can access it internally no problem (of course). However when attempting to connect externally, ie using mysql workbench, or even from an external server, I get the error message “Host ‘bla.bla.bla’ is not allowed to connect to this MySQL server&…
SQLYog-Like MySQL GUI For Linux? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and …
Why is this MYSQL statement giving me an error?
The file is there. I even pasted the path into the mysql console. The permissions are correct. In fact, I even tested it on root user and root mysql. Answer Note that when you do LOAD DATA INFILE, MySQL is looking for that file on the server – not on your client machine. If you want to use LOAD DATA
MySQL the command line and pagers
I cant find anything about this from searching here. I use mysql on the command line at work and I work with fairly large tables so I set the mysql pager allowing a more readable result if I run a query, that returns 1000’s of results. I use the command below to set the pager. This suits my needs but
Tracking down MySQL connection leaks
I have an application server (jetty 6 on a linux box) hosting 15 individuals applications (individual war’s). Every 3 or 4 days I get an alert from nagios regarding the number of open TCP connections. Upon inspection, I see that the vast majority of these connections are to the MySQL server. Shows 10,00…
Can you recommend a free light-weight MySQL GUI for Linux? [closed]
Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Questions asking us to recommend or find a tool, library or favorite off-site resource are off-topic for Stack Overflow as they tend to attract opinionated answers and spam. Instead, describe the problem and …