Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
2answers
5k views

phpMyAdmin - Display all queries

I have installed a fresh desktop with ubuntu quantal and the following packages versions: MySQL: 5.5.28-0ubuntu0.12.10.1 Apache: 2.2.22 (Ubuntu) phpMyAdmin: 3.4.11.1deb1 I would like ...
0
votes
1answer
2k views

MySql #2002 problem [duplicate]

Possible Duplicate: My MySQL installation is broken. How to completely reconfigure it? When i try to login in apache i get a #2002 error. When i try to login in MySQL via terminal it ask my ...
0
votes
1answer
1k views

Mysqld won't start after reboot

nothing in /var/log/mysql*. syslog shows: Oct 25 09:55:28 mx mysqld: InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 14:55:28 ...
0
votes
1answer
158 views

MySQL install error?

I'm trying to get a lamp server running on my ubuntu installation. I have SSH and Apache working without any problems. I installed MySQL with sudo apt-get install mysql-server mysql-client As usual ...
0
votes
1answer
239 views

What are the executable names of MySQL client and Admin Application (GUI)?

I've tried searching for for my MySQL client and manager using Dash Home, and cannot find them. I've tried using find on the command line, but don't know what the application names are respectively. ...
0
votes
1answer
509 views

cannot locate phpmyadmin

I successfully installed phpmyadmin, via apt-get install phpmyadmin However I can't find the directory for phpmyadmin, I want it to appear on /var/www/phpmyadmin so that I can use it via URL. Where ...
0
votes
1answer
462 views

After installing mysqli phpmyadmin stop loading

On Linux host 3.2.0-30-generic #48-Ubuntu SMP Fri Aug 24 16:52:48 UTC 2012 x86_64 x86_64 x86_64 GNU/Linux phpmyadmin won't load after installing mysqlnd. I'm using php5, mysql AND mysqlnd. Maybe ...
0
votes
0answers
23 views

How to instal LAMP for Ubuntu 12.04 LTS? [duplicate]

Possible Duplicate: What's the easiest way to set up a LAMP stack? I'm studying SQL database right now and I need a mySQL server. I was guided to use a LAMP server on Linux .. but I ...
0
votes
1answer
775 views

How to restore on another Ubuntu computer a MySQL backup made by rsnapshot?

How to restore on another Ubuntu computer a MySQL database backup made by rsnapshot on an external USB hard disk? This seems to be difficult because the UID and GID of mysql differ on both computers. ...
0
votes
1answer
933 views

Forward Mysql logs to Syslog-ng

Ubuntu 10.04 I have set MySQL to log slow queries and a general mysql log. How can I pipe those files in syslog to forward to centralized logging service (which is working)? Tried: source ...
0
votes
1answer
29 views

Installed program again in the “available to install” list

I have installed MySQL server and client from Ubuntu software centre. When I search for them from the dash home, they are listed under "Apps available for download" section. (If I search and find ...
0
votes
1answer
419 views

How to access MySQL server with user password issued through LibreOffice Base frontend?

When dist-upgrading Ubuntu 11.10 to 12.04 UpdateManager asked to enter a "new" user password for MySQL. I denied 3 times. This asking was put misleadingly. I better should have entered a user password ...
0
votes
1answer
43 views

Upload breaks after 3203 Inserts

I upload a textfile with approx 30'000 lines into a Mysql-DB. The upload breaks allways after exactly 3203 lines. A splitted file with less then 3203 lines runs fine. The problem is, for sure, not ...
0
votes
1answer
162 views

xamppp lampp unistall and error

Today I installed xampp from their website and just downloaded and extracted on my linux os (using tar xvfz) command and I started it using /lampp start. everything started perfectly and I wanted it ...
0
votes
1answer
645 views

MySQL access via PHP doesn't find database

I installed apache2, php5, mysql-server, php5-mysql, phpmyadmin in that order on Ubuntu 12.04 with the Software Center. Apache and PHP works fine, no problems. Also, if I try to work with MySQL via ...
0
votes
1answer
374 views

How do I automatically backup Mysql-Cluster database?

I need to automatically and frequently backup Mysql-cluster databases. How can I do this?
0
votes
2answers
596 views

Recovering mysql database from an unbootable hard disk

We have installed a Linux Authentication Gateway (run on Ubuntu Server) for more than a year ago. It has several features built in upon install such as Squid, php5, mysql, etc. The thing is this: we ...
0
votes
1answer
562 views

Errors when installing Mysql Server 5.1

I'm trying to install mysql server,and I'm getting the following error. sudo apt-get install mysql-server-5.1 Reading package lists... Done Building dependency tree Reading state ...
0
votes
2answers
1k views

Move mysql data dir to TrueCrypt volume

I have Ubuntu Desktop 11.04 and I'm trying to move /var/lib/mysql to a TrueCrypt volume and am failing at every attempt. This is for development purposes, and there's a particular database I need to ...
0
votes
3answers
996 views

MySQL error after rebooting (LAMPP)

I don't know if this is the right place to put this question. I installed Lampp and followed this instructions http://www.apachefriends.org/en/xampp-linux.html#377 and everything worked fine until i ...
0
votes
5answers
13k views

Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

I've been struggling with this issue for a really long time. Can someone please advise me on how to get mysql working? root@me:~# start mysql start: Job is already running: mysql root@me:~# mysql ...
0
votes
0answers
545 views

Upgrade to mySQL 5.5 on Ubuntu 11.04 [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? I've seen that mySQL 5.5 has a lot of innoDB performance enhancements. Is ...
0
votes
1answer
215 views

Is it possible / avaliable to Upgrade to MySQl 5.5 [duplicate]

Possible Duplicate: How do I upgrade MySQL to 5.5, am I best off waiting for it to be available through apt-get? Upgrade to MySQL version 5.5? If so. It is not in the synaptics package ...
0
votes
1answer
4k views

How to run mysql commands through shell script?

mysql -u root -pmysql; SELECT TABLE_NAME AS "Table Name", table_rows AS "Quant of Rows", ROUND((data_length + index_length)/1024/1024,2) AS "Total Size Mb" FROM information_schema.TABLES WHERE ...
0
votes
2answers
197 views

How to stop mysqld process?

result of ps -e | grep mysqld running htop and clicking on memory usage.. It is taking 33% of 4gb memory. I just want to end the mysqld process.. running sudo pkill mysqld ends the process but ...
0
votes
2answers
2k views

Errors installing php5-mysql extension

Getting error when installing php5-mysql. Looks like a dpkg error. Perhaps a broken package. Have tried to fix the broken package. Have reinstalled the lamp server and everything seems fine except ...
-1
votes
4answers
8k views

How do I start/stop mysql in XAMPP?

I installed XAMPP. Now the problems are I can not start mysql root@ubuntu:/# sudo /opt/lampp/lampp startmysql XAMPP: Starting MySQL... XAMPP: Couldn't start MySQL! I can not put my projects so i can ...
-1
votes
1answer
49 views

phpMyAdmin doesn't work when installing from repo

I've just installed phpMyAdmin via apt-get and rebooted. When i enter '127.0.0.1:3306' into web browser, i get something like this: I'm totally new to mysql but quite experienced with linux. How ...
-1
votes
1answer
425 views

How to connect to sql server 2008?

I am using ubuntu 12.04, and i have a microsoft sql server 2008 which is running on a windows server 2008 on port 1433, but windows server 2008 is virtualized it is running on vmware and further this ...
-1
votes
1answer
8k views

How can I use Mysql command line client in Ubuntu 12.04?

I just upgraded Ubuntu 11.10 to 12.04 (installed within windows 7) and during installation the process asked me to set my Mysql root password. According to Ubuntu Documentation, Mysql server is ...
-1
votes
1answer
313 views

/dev/sda1 100% Mysql to blame?

I have a an API running that receives raw binaries, processes them, and then stores metadata about the bins in a mysql database. I have been running it for a couple days on a VM. Today the API stopped ...
-1
votes
1answer
232 views

Best approach to automatically processing .csv --> MySQL [closed]

Bump this to the proper place if necessary. Not sure where I can get the best response. I need to create a reporting application and would like to do it with Ubuntu if possible. The originating data ...
-1
votes
3answers
111 views

What Is the Best UBUNTU script for installing LAMP [duplicate]

I have tried to install LAMP on Ubuntu 14.04LTS Cant get PHPmyAdmin to work and access MYSQL Where is the clearest set of instructions to install LAMP
-1
votes
1answer
149 views

Managing a corrupted apt-get state [closed]

I'm extremely frustrated with apt-get (and probably dpkg also). At least once or twice per year my apt-get will mess things up on my server which requires a total reinstall of my Debian OS. This ...
-1
votes
2answers
125 views

how to connect to mysql server in another system from ubuntu

I am using ubuntu, and am programming in android. So in my application i need to connect to mysql database which is in another system. When i searched, i foud that wamp server is need, wanp only works ...
-1
votes
2answers
674 views

Why does my MySQL remote-connection fail (VLAN)?

ubuntu-community! Again I have a problem with my special friend MySQL :D I have got two servers - a database-server and a web-server - who are connected via VLAN. Now I want the web-server to have ...
-1
votes
0answers
18 views

How can I setup c++ so that I can also use mySQL? [closed]

I don't know if my title is correct but I am using Ubuntu 14.04 and basically I have just installed Netbeans version 8.0.1 with the C/C++ plugin and I want to work with mySQL for an assignment of ...
-1
votes
1answer
2k views

Issues installing MySQL server on Ubuntu 13.04

I'm currently trying to install a MySQL server on my Ubuntu 13.04 machine. The problem is, when I try to install it, I get error messages indicating that not all packages could be downloaded. When I ...
-1
votes
2answers
96 views

Should I use desktop or server version for my own java+mysql trading system? [duplicate]

I am going to build a trading system with java and mysql but I am not sure should I use desktop or server version. The backtest part would involve a lot of calculation and live trade part requests ...
-1
votes
1answer
435 views

myloader Segmentation fault (core dumped) [closed]

myloader --directory=$DB_DUMP --queries-per-transaction=50000 \ --threads=$THREADS --compress-protocol --verbose=3 \ --socket=$MYSQL_SOCK --user=$MYSQL_USER --password=$MYSQL_PASS # ...
-2
votes
1answer
163 views

Database error. Wordpress. MySQL have shut down at 10:00 am

Could you please tell me what's wrong with my MySQL? Ubuntu 14.04. I can't understand what's going on.. 140912 10:00:55 [Warning] Using unique option prefix myisam-recover instead of ...
-2
votes
1answer
382 views

dependency problems at installation from mysql-server-5.5 [closed]

qcons@014-QCONS:/var/lib$ sudo apt-get install -f mysql-server Paketlisten werden gelesen... Fertig Abhängigkeitsbaum wird aufgebaut Statusinformationen werden eingelesen... Fertig ...
-2
votes
0answers
41 views

KUBUNTU can't install XAMPP [on hold]

I downloaded x64-5.6.3-0-installer.run. I right click on it go to permissions click "is executable", click ok. Then go in Konsole on the download folder: and type sudo su then type: ...