Questions regarding the MySQL database server, client and tools.

learn more… | top users | synonyms

1
vote
3answers
397 views

Migrate whole mysql to another server [closed]

I'm switching from a vps to another one and i need to migrate my mysql server. Is there an easy way to backup/restore ALL databases and users (with permissions) at once? Many thanks
4
votes
1answer
13k views

Installing MySQL 5.6 using PPA

I'm trying to install MySQL 5.6 on my Ubuntu 12.04 over the already installed 5.5 the easy way (using PPAs). I've found Ondřej Surý's PPA here. It sounds promising but I couldn't upgrade my MySQL. ...
0
votes
2answers
922 views

Server crashed a few times due to lack of memory - how can I find out how much is available to each process? [duplicate]

We had a huge spike in traffic with lots of these errors: Feb 17 10:44:13 111488 kernel: [8275767.506198] Out of memory: Kill process 20577 (apache2) score 52 or sacrifice child Feb 17 11:02:06 ...
5
votes
2answers
15k views

Optimising MySQL settings - mysqld running out of memory

I'm a bit confused about which settings to change in my my.conf file to optimise for my server (the mysql server keeps crashing due to our high traffic). Here's the my.cnf file: [mysqld] user ...
2
votes
2answers
5k views

How can I activate MySQL Database Server?

I have a problem with my xampp that's installed on Ubuntu 12.04 64-bit. After successfully installing my xampp server, I do get access to the lampp server which further indicates that the mysql ...
2
votes
2answers
12k views

Trouble Installing MySQL workbench [closed]

I am new to Ubuntu Linux. My Professor asked us to download Ubuntu 10.10. I have made several attempts to download MySQL as 32 and 64 bit in Debian packages and it keeps failing. See below for what i ...
0
votes
1answer
344 views

i want to install my sql client and server

i need to form network like "directory service" i am using ubuntu 13.10 client and 13.10 server i need to install "my sql server and client" Thanks and regards in advance
1
vote
1answer
94 views

Where is the database file from redmine after using the defaultinstallation?

After I installed redmine, I have a database called redmine and through phpmyadmin I can take a backup etc. , but I can't find the default location of it. Where is it placed? Any Idea? Does mysql ...
0
votes
2answers
2k views

mysqldbcopy: command not found

I am trying to run a script that requires usage of the mysqldbcopy tool. From reading the ubuntu manual, it appears that one just needs to install the mysql-utilities-1.3.5-1_all. When entering that ...
0
votes
1answer
136 views

Mysql died and won't start

I am working on Ubuntu 12.10 server with nginx, mysql and unicorn installed. There is something wrong with Mysql and has stopped working. Log message from /var/log/mysql/error.log Attempting ...
0
votes
1answer
283 views

HTML doesn't show php script on Uuntu 12.04 ( PHP5, Apache2, mysql) all are installed properly

But info.php in /var/www/ does show the info. Only PHP embedded in html doesn't show the script. please help me.. I have tried the previous askubuntu questions and didnot get anything useful so ...
3
votes
3answers
835 views

How to concate strings in a bash script to use in SQL-Statement? [closed]

I would like to do the following in a bash script: read some filenames out of an file with filenames set a variable input path concat 1. and 2. use 3. in sql-statement Here my code: ...
1
vote
1answer
991 views

mysql statement in bash shell script does not work / syntax error

hope someone can help me! I do not know what's wrong with this script (Bash / Ubuntu 12.04 / Mysql / XAMPP 1.8.3). Try to read an input file with a list of csv-filenames (449-R11, 449-R12 ..) in order ...
1
vote
2answers
7k views

Installing mysql 5.1 with Ubuntu 12.04

I have Ubuntu 12.04 installed, I need to install mysql 5.1 in that. Following steps I performed: Other things to be installed: Run this command to install alien and other necessary packages if not ...
15
votes
1answer
14k views

Start MySQL on Startup

I installed MySQL, and changed the configuration so the databases are stored on a separate hard drive. In the process MySQL has stopped starting up automatically. When I start the computer, I need to ...
1
vote
0answers
375 views

“package mysql-server is not installed” even when it is installed

I am trying to install a deb package running the command dpkg -i code/mydeb.deb it gives an error saying dpkg: dependency problems prevent configuration of openmrs: openmrs depends on ...
0
votes
1answer
450 views

Can't run PHP script accessing my Mysql databse

I've created LAMP server in my ubuntu desktop. I've also made a sample database in Mysql having 6 columns. I can access it through the terminal. I've also created a php script for accessing the same. ...
0
votes
2answers
2k views

Mysql query browser or any Mysql gui tool in Ubuntu

I have installed Ubuntu 13.04 and now fully dependent on it. I have worked on mysql query browser in windows to run queries and procedures and programmers ,i could not find any other alternatives in ...
0
votes
1answer
226 views

mysql with ubuntu 13.10

I have a problem with mysql-server and client after a wrong configuration. I tried uninstalling both but I get an error when I uninstall mysql-server: start: Job failed to start invoke-rc.d: ...
0
votes
1answer
288 views

mysql server in ubuntu 13.04 not showing databases

i have installed Xampp(LAMPP) in Ubuntu 13.04 . i have secured the xampp phpmyadmin Mysql FTP. status showing ACTIVATED.now, i have installed mysql server.in terminal write mysql -u root -p and then ...
2
votes
2answers
10k views

Script timeout passed, if you want to finish import, please resubmit same file and import will resume

I am getting this error while importing the database in mysql, and when I resubmit the same file than I am getting this error Error SQL query: -- -- Dumping data for table `adminnotification_inbox` ...
1
vote
1answer
2k views

MySQL won't start after removing bind-address

So, I am running mysql on an ubuntu server (command-line) VirtualBox, on a Windows 7 host. In the Virtual machine, I changed the /etc/mysql/my.cnf file by commenting out the line bind-address = ...
0
votes
1answer
550 views

Unable to create a file in a certain location on Ubuntu

I'm trying to create a text file as below... mysql --host=localhost --user=root --password=11111 database1 << EOF SELECT * FROM table WHERE status = 1 INTO OUTFILE '/home/user/feeds/file.txt' ...
0
votes
1answer
96 views

php and mysql issues

I've recently read Wallace Wang's “Beginning Programming for Dummies, 7 books in 1” and found it to be very enlightening, as it highlighted various differences between the three main operating systems ...
1
vote
4answers
48k views

accessing MySQL using terminal in Ubuntu 13.04

accessing phpmyadmin db from terminal now in ubuntu 13.04 i firstly installed mysql server with sudo apt-get install mysql-server mysql server version 5.5 now in terminal i can check if it is working ...
3
votes
3answers
14k views

How to change mysql port number in ubuntu

How can I can change port number of mysql from 3306 to my choice of number (1023) in Ubuntu 13.10? I tried by editing the port number in file: /etc/mysql/my.cnf. But after this change mysql doesn't ...
0
votes
1answer
235 views

12.04.4 + MySQL 5.5 + Wordpress - MySQL Service Fails to Start

It appears that the issue is around the MySQL services starting as I receive the following in my /var/log/syslog when I attempt to restart the mysql service: Jan 17 08:19:38 blog kernel: [ ...
0
votes
1answer
114 views

cron not outputting correctly?

Please forgive my ignorance. I have searched, but perhaps I’m not sure really what to search for in order to answer my question myself, so I’m turning to this forum for a little guidance. I’ve ...
0
votes
1answer
662 views

How to set up Apache/MySql/Django environment for development

I've only been able to find tutorials to set up Apache/MySql/Django on servers, but I'd like to set up an environment on my machine for development. Does anyone have any good tutorials or suggestions? ...
0
votes
1answer
2k views

Installing libmysql on Ubuntu Server 12.04

I really need help installing the dependency of this, which is libmysql (here) I really have no idea how to install it. The author requires me to put it in a specific directory, but I have had no ...
0
votes
1answer
2k views

Can't Connect to MySQL via CLI or phpMyAdmin, but WordPress still connects fine

This is the first time I've had to reach out for a question -- I'm truly stumped. I have mysql up and running on a linux server (Ubuntu) and this morning tried to login to phpMyAdmin. I received an ...
1
vote
2answers
713 views

Unable to locate package libmysql++-dev

root@avidgamers:~/warcraft/aG-HostbotRU/ghost# apt-get install libmysql++-dev Reading package lists... Done Building dependency tree Reading state information... Done E: Unable to locate package ...
1
vote
2answers
2k views

How can I import multiple .sql files into MySQL?

In my folder, I have a lot of *.sql files... How via one command I can import them? For example; is something like this possible? mysql -u root -p db_development < *.sql If not, how can I ...
8
votes
1answer
5k views

Tora: No connection provider

I install tora on ubuntu 12.04. When I try to open, I'm unable to connect mysql database. Tora is not showing option for mysql.
4
votes
2answers
7k views

Is there a free MySQL manager with a visual query builder for Ubuntu?

I need a free MySQL manager with a visual query builder. I used to use EMS manager for MySQL in Windows but since I'm trying to be a Ubuntu user now, I need another tool with a visual query builder ...
1
vote
2answers
1k views

Ubuntu 13.10 apache keeps giving this error while accessing website

I have just installed Ubuntu 13.10. I followed this guide (most of it) to setup LAMP. Then I was getting this error about Could not reliably determine the server's fully qualified domain name ...
0
votes
1answer
1k views

How can I get mysqldump to use the credentials from mysql_config_editor in a crontab-executed script?

I am setting up a daily backup of a MySQL 5.6.14 database using mysqldump on an Ubuntu 12.04 Precise server. I created the credentials file in the root home directory (.mylogin.cnf) according to the ...
1
vote
1answer
5k views

Install ODBC connector for PostgreSQL on Ubuntu Server 12.04

I try to install the ODBC driver for PostgreSQL on Ubuntu Server 12.04. The purpose is to connect R (which is also running on the Server)to the database. I somehow got stock because I did not find a ...
2
votes
1answer
232 views

sendmail & MySQL

I had MySQL and PHP working good in the nginx server. For mailing purpose I installed sendmail. Now all I get is Your PHP installation appears to be missing the MySQL extension which is required by ...
0
votes
1answer
61 views

Mysql/php connection

I'm a newbie to ubuntu,and im trying to connect the mysqlworkbench(database) with php5.3 if (function_exists('mysql_connect')) { echo "Good<br />\n"; } else { echo "Bad.<br />\n"; } ...
27
votes
3answers
246k views

ERROR 1045(28000) : Access denied for user 'root@localhost' (using password: no )

I'm trying to install queXS cati app on my Ubuntu desktop and I installed MySQL server and PHP 5 and I cannot login into MySQL server as root without password: mysql -u root it says ERROR ...
1
vote
1answer
423 views

MySQL script does not stop, reboots mysql

I have installed ubuntu 13.10 desktop x64 on my laptop. After the installation I installed MySQL Server sudo apt-get install mysql-server mysql-client Installation wass successful but I noticed the ...
0
votes
1answer
821 views

Connect to mysql database on Ubuntu host from windows guest

I have Ubuntu 12.04 on my laptop and have a Windows 7 guest on (VMWare). I would like to connect to the mysql database on Ubuntu host from Windows guest.Kindly tell me how to do the same. I have tried ...
2
votes
1answer
512 views

what is the command to connect a database remotely from other PC

what is the command to connect a database remotely from other PC. I am running a application in a PC1(client) and storing some content of that application on a database. There is also one another ...
1
vote
2answers
5k views

Cannot compile mysql code

I have the following code #include <my_global.h> #include <mysql.h> int main(int argc, char **argv) { printf("MySQL client version: %s\n", mysql_get_client_info()); exit(0); } ...
3
votes
2answers
366 views

How could I successfully log in under a non-existent user account?

I'm trying to setup ownCloud in a test lab. I somehow managed to create a 'owncloud' user (which is fine). The account has an empty password (I'm not sure how that happened), so I'm trying to set one: ...
3
votes
2answers
7k views

Updating variables in my.cnf

I set lower_case_table_names = 2 in /etc/my.cnf file. I also updated this variable in /etc/mysql/my.cnf file. After setting the variable I restarted mysql server, but still the value is 0, when I use ...
1
vote
0answers
22 views

Ubuntu Mysql suddenly locked me out [duplicate]

I'm experiencing a very weird problem here. I was using a mysql database for developing a rails app and everything was fine. Then I rebooted the computer (Ubuntu 13.10) and found myself locked out of ...
0
votes
1answer
41 views

autogenerate javascript from mysql

I have a site where I can upload images with some info (startdate, enddate, duration, url) I want to make a SlideShow that choose those pictures that is > $startdate && < $enddate. And I ...
1
vote
1answer
3k views

What makes mysql service autostart, while it's disabled in BootUp-manager?

The mysql service is not enabled in BootUp-manager, yet it is working after system starts. Is it awaken by another service? How to determine what causes that? EDIT Fix as instructed here.