Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

0
votes
0answers
19 views

Installation of MySQL Server 5.5 freezes on Ubuntu 12.04 LTS [duplicate]

I try to install MySql Server 5.5 on a virtual machine running Ubuntu 12.04. After executing sudo apt-get install mysql-server I get this screen: It seems that the installation is frozen. Any ...
0
votes
1answer
200 views

Can someone make this modx .htaccess file work for me? I am trying to make friendly URLs work

I now have my ModX install working but am unsure how to edit my htaccess file so my friendly urls (trying to alias pages) can anyone help? If you can a copy of my htaccess can be found at ...
0
votes
1answer
429 views

Ubuntu 12.04 Mysql Won't Install

Error when i trying to install mysql-server on Ubuntu 12.04 AppArmor parser error for /etc/apparmor.d/usr.sbin.mysqld in /etc/apparmor.d/usr.sbin.mysqld at line 9: abstractions/mysql start: Job ...
0
votes
1answer
62 views

upgrade to 12.04, mysqld up but can't log on

Sorry if this is the wrong place to post. I upgraded to 12.04 and mysql stopped working. I re-installed mysql server package. When I try to log on to database I get: ERROR 2002 (HY000): Can't ...
0
votes
1answer
4k views

mysql: unrecognized service (apparmor)

Many questions on this point but I couldn't any help yet. Mysql was working then I tried to move mysql database directory as (in this ...
0
votes
1answer
362 views

why phpmyadmin didn't work?

When run phpmyadmin it is not working and i get this message: Not Found The requested URL /phpmyadmin/ was not found on this server. Apache/2.2.22 (Ubuntu) Server at localhost Port 80 How it's not ...
0
votes
1answer
341 views

How to access Ubuntu server 12.10 via hostname,

I had it working, but then installed LAMP and a few other things to set up a webserver, now PUTTY only allows connection via IP, which works, and Webmin worked with hostname as well, until now... I ...
0
votes
1answer
533 views

MySQL broken on localhost since update

all. After a recent 12.04 update (MySQL was updated), when trying to access my localhost site I get the following error: Database Error: Unable to connect to the Database: The MySQL adapter 'mysql' ...
0
votes
1answer
4k views

Problem after mysql-server installation I cant install any thing in ubuntu 12.04.1 now

I'm not an advanced user of Linux and I tried to install work with database so I installed Mysql-server, I think I did same thing wrong so I get in trouble and now I cant install any thing and this ...
0
votes
1answer
968 views

ERROR 1018 (HY000): Can't read dir of './depot/' (errno: 13)

I want to use of symbolic link for change path database in mysql. I create a Directory ,then create a symbolic link to this directory but when I want to use of this database get following error: ...
0
votes
1answer
1k views

I can't start mysql in ubuntu 11.04

I downloaded following files of Oracle.com: MySQL-server-5.5.28-1.linux2.6.i386.rpm<br/> MySQL-client-5.5.28-1.linux2.6.i386.rpm<br/> MySQL-shared-5.5.28-1.linux2.6.i386.rpm<br/> ...
0
votes
1answer
550 views

How to make a Portable Server for ubuntu?

I want my server to be portable so it will be available everywhere when I plug it in to other ubuntu computers. Like I want to use it at school, I will just have to run a script and the server runs. ...
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
159 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
242 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
528 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
477 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
789 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
938 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
420 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
652 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
382 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
601 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
568 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
1k 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
362 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
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
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
54 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
651 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
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
233 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
130 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
172 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
129 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
691 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
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
97 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 ...