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 friends
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 mysql_upgrade…. Anyway, thanks for the help
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: If no DB exists, the output will look
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”. I have done: GRANT ALL PRIVILEGES ON *.* TO mysql@x.x.x.x IDENTIFIED
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 what has been done so far to solve it. Closed 8 years
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,000+ connections on the MySQL server from the
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 what has been done so far to solve it. Closed 9 years