MySQL is a relational database management system (RDBMS) that runs as a server providing multi-user access to a number of databases. MySQL is officially pronounced /maɪˌɛskjuːˈɛl/ ("My S-Q-L"), but is often pronounced /maɪˈsiːkwəl/ ("My Sequel"). It is named for original developer Michael Widenius's ...
0
votes
0answers
6 views
How do you get MySQL Workbench to only sync the tables you're working with?
Ive accidentally deleted my database a couple of times already having to reload abotu 150 GB of data -- all because I accidentally hit next without selecting which tables to ignore when MySQL Model ...
0
votes
0answers
9 views
Writing to Net and Cleaning up in Show Full Processlist in mysql, what does it mean?
Sometimes when i run show full processlist, it come with these in status, ie:
with this query:
select count(*) as ...
could it be some problem?
0
votes
1answer
32 views
One slave, multiple masters MySql [closed]
Is it possible to set-up MySql Replication to have one slave listening to two different masters?
-3
votes
0answers
41 views
How can I improve the speed of this SQL query? [closed]
select a.err,a.msgal,a.id,a.lista_id,a.sms_id,a.msg_id,b.numero
from sms_envios a,sms_numeros b
where a.lista_id=b.lista_id and ((a.err=1 and a.err=b.err) or a.err=0)
order by a.id asc,b.id asc
...
0
votes
4answers
69 views
systemctl enable differs from systemctl start, how?
I am running an Arch Linux (latest, up-to-date) box, and attempting to get MySQL to start at boot. With the systemd package installed I have systemctl available, and as such I can do things like this:
...
0
votes
0answers
55 views
Connecting to mysql on localhost using external hostname
I'm trying to connect to my server using the external IP Address...
This works from an external machine but not from the machine which is running mysql.
This is annoying as I would like to use the ...
0
votes
0answers
25 views
permission error when installing MySQLdb module for python without root
I don't have root access to a machine (Linux), but I would like to install the MySQLdb module (or any other MySQL module) for python.
I have tried my usual approach (python setup.py install --user) ...
0
votes
0answers
48 views
Can't re-install MySQL on OS X Leopard after uninstalling
I'm running Leopard (10.5.8) on a Macbook (not Pro) and I had MySQL running ok, but the Preferences pane wasn't working. I thought a fresh install would be a good idea, so I went through the uninstall ...
0
votes
1answer
37 views
Uninstall MySql on OS X
I accidentally installed the binary package of MySql on my Mac OS X.
Now I don't see anything about MySql. How can I uninstall it?
0
votes
1answer
15 views
multiple server set up for web based application
First off please excuse me if this is short and sweet as I'm typing this from a phone currently..
Overall I am trying to find out specifics on setting up multiple dedicated machines for hosting a web ...
0
votes
2answers
52 views
Syntax Highlighting for MySQL Shells?
Are there any MySQL shells that support syntax highlighting? I know in my.cnf, you can set the shell string with, for example:
[mysql]
prompt=(\\u@\\h) [\\d]>\\_
But is there any more ...
0
votes
0answers
9 views
3 Table, SQL Query [migrated]
I am trying to write a SQL query that pulls from 3 tables and haven't been able to achieve the results I need. I want to return all the property names (labels) that are paired with a particular ...
0
votes
1answer
30 views
Errors reinstalling MySQL Server
I am trying to re-install MySQL on Windows 7.
While installing MySQL server initialization configuration Wizard,
when I hit the 'Exceute' button on the MySQL Server Instance Configuration screen it ...
0
votes
1answer
29 views
Using Plesk to setup MySQL
Having trouble getting my mysql up and running on a new virtual server. The host gave me Plesk and I think MySQL is installed but I can't seem to access it.
I keep getting this:
mysql -u admin -p
...
0
votes
0answers
6 views
Best process of translating/proof reading text from mysql database
We're developing a multilingual web app with all texts stored in various tables in MySQL databases. When we send texts out for translation (or proof reading) we usually export to excel. Some ...
0
votes
1answer
16 views
seq with regex, error message for mysql quotes
Is there some tool that auto quotes regex for seq?
I can't figure out what I'm doing wrong. I always get this error unterminateds' command`
sed -i 's/INSERT INTO `tablename.*`/INSERT INTO ...
1
vote
1answer
21 views
Being 'nice' with I/O: limiting a processes I/O resources in *nix
I'm working on a big shared Ubuntu server and am annoying my colleagues. One of my processes is making a lot of inserts into a MySQL database and it's bogging the whole server down.
MySQL is not ...
-3
votes
0answers
94 views
How to upload files to a WWW server?
I want to change my WWW pages.
I have a user name and a password on our FTP server for accessing my WWW space. I logged in with those and I created some directories; but I can't copy files into ...
1
vote
1answer
37 views
Reduce MySQL memory usage on a development box
On my mac, after a fresh restart with zero connections, MySQL is currently using 40MB of memory, 188MB of virtual memory (on-disk database paged in?), and has 16 threads.
Since there's only ever one ...
0
votes
1answer
42 views
MySQL client not working in Windows XP
I have installed MySQL via Windows installer from the MySQL Site
When I click on MySQL client, it shows me nothing. It just closes very fast, which is why I can't see anything.
I have 4 parts:
...
1
vote
0answers
25 views
How to run Percona with WampServer on Windows XP?
I was wondering if anyone knows if its possible to install Percona (mysql replacement) and use it with WampServer on a Windows XP machine. If so, does anyone know where to start?
0
votes
0answers
29 views
How to install MDB2 for pear on Windows 7?
I am trying to install MySQL, PHP pear, and I don't know how to install MDB2 on Windows 7. Should I install Wamp first?
0
votes
0answers
11 views
Is there any way to increase the mysql reserved pool for super users beyond 1? [migrated]
http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html
States that there is 1 connection beyond your maximum number of connections for users with the super privilege.
My question is can ...
2
votes
2answers
90 views
Public MySQL servers for use in sample code
Similar to how the IETF's example.com domain's web and email services can be safely used in code samples, is there a public MySQL server I can safely(*) use in some sample code?
("Safe" in that it ...
1
vote
3answers
83 views
Small hardware for linux? [closed]
Can anyone recommend some hardware which meets the following criteria:
USB port (more than 1 would be handy but an USB hub could always be used)
Suitable for running a reasonably small linux ...
0
votes
1answer
81 views
Very simple private videos script? [closed]
I'm in the process of searching for a PHP/MySQL script for a site where the admin could upload videos and asign them to users. This is for a training site.
Do you know of such a PHP/MySQL script? Or ...
1
vote
4answers
63 views
Mac - Better GUI MySQL tool than phpMyAdmin
I've been running into a lot of shortcomings with phpMyAdmin, especially when it comes to anything Foreign Key related. Imports and Exports can be shady, and working with large amounts of data is a ...
0
votes
0answers
43 views
2
votes
1answer
76 views
How to completely remove MySQL files from my windows computer
I have recently installed apache, php, and mysql. Apache and php are configured properly, but when I tried to configure mysql it shows that there is already a security file for mysql that is setup and ...
0
votes
1answer
101 views
How can I change MySQL's root password with AMPPS?
How do I change MySQL's root password using AMPPS?
When I try to change MySQL's root password from AMPPS' home, it gives me an error saying:
Old Password field is empty.
How can I solve this? ...
1
vote
1answer
27 views
MySQL Workbench Snap To Grid
I'm using MySQL Workbench 5.2.36 in OS X and was wondering where in the options is the Snap To Grid function when editing a model?
I can find Show Grid, but that's all... it's sort of pointless ...
0
votes
1answer
42 views
How to keep PHP and MySQL of ampps as default in MacOSX?
I'm using MacOS X 10.6.2. I want to use AMPPS http://www.ampps.com/ as my local development server so my question is how do I keep my AMPPS PHP & MySQL default?
1
vote
1answer
55 views
Enable PHP extensions on Windows system
I'm using Apache 2.2 along with Windows 7. I just need to enable MySQL extension to work. Its okay when I'm using windows binary (.msi). But when I'm trying with .ZIP file, MySQL extension is not ...
2
votes
2answers
18 views
mysql when in command line how to jump previous line
How to jump previous line when in mysql console ?
i want jump to FROM line ?
Sory for my bad english.
1
vote
1answer
145 views
http://localhost:8080 is not working on running apacher Server through XAMPP
I am unable to configure a PHP/MySQL/Apache environment on my local machine using XAMPP.
In my xampp control panel the Apache and MySQL status is shown as started, but localhost URL is not working.
...
0
votes
1answer
103 views
Issues Installing MySQL 5.5 manually on Ubuntu 10.04 server, errors about “/tmp/mysql.sock”
I've set up an Ubuntu server and wanted to install MySQL 5.5. I've been following these MySQL documentation steps.
I have libaio dev installed. Everything went fine until I ran
bin/mysqld_safe ...
1
vote
1answer
87 views
Amazon EC2 (Linux) + RDS (MySQL) + PHP + pdflatex = LaTeX to PDF online
I would like to have a website capable of converting LaTeX documents to PDF online. So for example user types in some raw LaTeX (document), I'm saving it into my MySQL database and I'm able to convert ...
0
votes
0answers
16 views
mysql workbench visualization for schema
i have an existing database and have recently downloaded mysql workbench. I was wondering if anyone could walk me through how to navigate the workbench and how to get a visualization of the RDB. I'd ...
0
votes
0answers
50 views
mysql ssl replication account login works, replication fails
I'm using openssl to test mysql replication ssl in local network. I could login from the slave to the master using mysql command.
mysql -u repl --host=192.168.0.205 -p ...
1
vote
1answer
37 views
How to retrieve all MySQL settings?
I have a configured MySQL server (MySQL 5.1.47-community) that works perfect. I installed a second server (MySQL 5.5.15-community) to see if the new version of MySQL would work with my application ...
0
votes
0answers
19 views
Error in installing MySQL 5.5 on Win7
I have problems installing MySQL in apply security setting. I adjust in 3306.
I click the retry button but it doesn't work.
error number:1045
access denied for user root@localhost using password:no
...
0
votes
0answers
21 views
How do I used memcached with sphinx?
Does anyone have any details explaining how to use memcached with sphinx?
I am using:
Centos 6.0
Sphinx 2.0.1
Mysql 5.5.17
Apache 2.2.15
I have installed memcached and would like to cache queries in ...
0
votes
1answer
69 views
Can't delete MySql service on Windows using sc from the command line
I removed MySQL but there is still a service running. I stopped the service and ran SC Delete MySQL.
This is the error that I receive:
[SC] OpenService FAILED 5:
Access is Denied
OS: Windows ...
0
votes
0answers
20 views
Windows Server 2003: Install PHP, mySQL etc
At my workplace there is a Windows Server 2003 machine that we use to host file servers and an existing (legacy) .net web application. I would like to install a wiki and some other php/mySQL backed ...
0
votes
2answers
42 views
Setup MySQL on a Mac
How can I set up a MySQL server on my MacBook Pro? I already used Homebrew to install MySQL, but now I don't know what to do.
0
votes
0answers
50 views
How could Arch Linux lose info due to a corrupt MySQL database? [closed]
I first used MySQL about 12 years ago, it seemed pretty reliable and relatively performant, although I do remember the odd crashed server and having to run myisamchk etc.. first with one set of ...
1
vote
1answer
1k views
Uninstall LAMP Ubuntu 11.10
I recently installed a LAMP stack on my Ubuntu 11.10 machine so I can work a little more easily with some of my outside work. However come to find out the lamp stack is conflicting with my core paying ...
1
vote
1answer
37 views
MySQL Remote Connections & Dynamic IP
I'm just configuring a remote test machine for my development team.
As not being a administration guru I faced one issue only (and I'm really proud of it).
We have dynamic IP addresses in the office ...
0
votes
1answer
56 views
Different output when redirecting
$ mysql -e 'select a,b from tablefoo' databasename
yields
+---+---+
| a | b |
+---+---+
| 1 | 0 |
| 2 | 1 |
+---+---+
whereas
$ mysql -e 'select a,b from tablefoo' databasename > file
...
1
vote
1answer
27 views
MySQL options file connect to remote servers without typing password
I have a [client] option group with my local credentials for my database, which lets me quickly access my database from the CLI.
Can I set something up the same way in this file so that I can access ...
