An open-source, relational database management system.

learn more… | top users | synonyms

1
vote
1answer
1k views

Why don't I see the XAMPP page on Linux Mint?

I am trying to install PHP MySQL on Mint 12. I downloaded and installed XAMPP. According to the tutorial, when I go to localhost in a browser I should see this: Instead, I see: It works! This is ...
4
votes
1answer
149 views

If I'm logged in as root, how do I restart mysql or apache with options?

I know the commands to restart/stop/start, but when I try to pass options it doesn't seem to work! CENTOS 6, MySQL 5.14 service mysql restart service httpd restart Then I tried this: ...
2
votes
0answers
1k views

MySQL socket and PHP (and other languages)

Background info I'm currently running CentOS (or Red Hat?). uname -a gives (I edited out my domain name) Linux XXXXXXXXX.com 2.6.32-71.29.1.el6.x86_64 #1 SMP Mon Jun 27 19:49:27 BST 2011 x86_64 ...
1
vote
2answers
4k views

Can't start mysqld

I've installed mysql through $ sudo apt-get install mysql-server-core-5.1 $ sudo apt-get install mysql-client-core-5.1 This is my current conf file And the service won't start, at first the ...
3
votes
1answer
2k views

How to enable an federated storage engine in the Debian MySQL package?

How would I enable an extra (in this case FEDERATED) storage engine in the mysql-server-5.1 package from Debian? I've installed mysql-server-5.1 via apt-get. But the SHOW ENGINES shows that federated ...
0
votes
2answers
444 views

How do I install software on Fedora 13?

I installed Fedora 13, but it doesn't come with a lot of software I want -- office tools, productivity, GUI environments, MySQL, and Kamailio. How do I get all this stuff onto my Fedora install?
3
votes
2answers
4k views

How to grant a “no-root-user” rights to start/stop/restart mysql server on suse machine?

Is it possible to grant priviliges to a "no-root-user" to start and/stop/restart the mysql server on a suse machine? The goal is to make it for a developer possible to tune a mysql server/database ...
5
votes
1answer
15k views

How can I completely reinstall mysql?

I had to reboot in the middle of a large data import. I only have one mysql database, which has now been corrupted. How can I completely remove mysql and reinstall it? I've tried apt-get purge ...
2
votes
1answer
4k views

Brute force access to a Firebird database?

Ok, so here's the deal. When migrating a certain product with terrible documentation to another database type, my Firebird database was deleted. I then proceeded to recover it from the filesystem ...
1
vote
0answers
581 views

Can't make a copy of /var/lib/mysql/ibdata1

I have a RedHat Linux server and I'm trying to make a copy of /var/lib/mysql/ibdata1, but I'm receiving an error saying permission denied and the file cannot be opened. I'm logged in as root user and ...
1
vote
3answers
1k views

Error dropping database in MySQL 5.1 on Ubuntu

I am using MySQL v5.1 on Ubuntu machine. I have a database named my_db which I would like to drop it, so I execute command: mysql> drop database my_db; ERROR 1010 (HY000): Error dropping ...
1
vote
4answers
2k views

Restart MySQL server

I am using MySQL v5.1 on Ubuntu machine. MySQL on my machine used to work. (Running mysql -u root gave me the MySQL command line.) This afternoon, I did the following thing: 1. check active process ...
3
votes
2answers
3k views

'mysql' user and group creation, ownership settings

I know what the linux command chown does, I used it to change the ownership or group of a file. If there is a MySQL installation on a Ubuntu machine, I saw some people doing the following thing: ...
1
vote
2answers
3k views

MySql: LOAD DATA INFILE

I am using MySQL v5.1 on Ubuntu machine. MySQL data directory is /var/lib/mysql/ I have a test.dat file located on /var/lib/mysql/tmp/test.dat I would like to load data from the test.dat file into ...
4
votes
1answer
750 views

Linux : Alternative of install_name_tool of MAC in CentOS

I am looking for alternative of install_name_tool of MAC in CentOS. Exactly I want to build MySQL on non default location. Also the shared libraries of the mysql binary should be on non default ...
1
vote
1answer
81 views

dump out some tables of the database

I am using MySQL v5.1 on Ubuntu machine. I have a database named db_test which contain tables like cars, customers, departments, prices , and so on. I know I can use the following commands to dump ...
2
votes
2answers
6k views

Can I copy a MySQL database by copying the files? What do the files contain exactly?

I am using MySQL database and using an Ubuntu Linux machine. My database named db_test , I notice that under path /var/lib/mysql/db_test ,there are files suffix with .frm, .MYD, .MYI like following: ...
3
votes
2answers
770 views

Installing php-cgi under Ubuntu for Cherokee web server

I have set up Cherokee web server on my server, and want to enable PHP and MySQL support for applications like Wordpress and phpBB. I have tried running these commands: sudo apt-get install php5 ...
1
vote
3answers
3k views

Troubles installing php with MySQL support

So I wasn't sure if this question would go best here or on Overflow or Server Fault, but decided to try here first. I'm installing LAMP on a VPS, and am running into issues configuring and building ...
0
votes
2answers
583 views

Need to install MySQL Client libaries but RPM not installing them

I'm trying install the MySQL Client libraries for the Perl Mod of the same name but when I run sudo rpm --install -v --allfiles MySQL-client-5.5.16-1.linux2.6.i386.rpm and querying the rpm ...
2
votes
2answers
296 views

List files that occur lexically after/greater than a given prefix (or, run database upgrade scripts in a proper order)

I'm trying to create a shell script that runs through a bunch of SQL scripts. I've these files: $ ls upgrade/ 01-foo.sql 02-bar.sql 02-baz.sql 03-foo1.sql 04-buz.sql And I've got the version of ...
4
votes
1answer
6k views

start mysql server at boot for debian

I am using Debian Etch and I have following this and tried to write a script like this to auto start mysql server at boot: #! /bin/sh # /etc/init.d/blah # # Some things that run always sudo ...
1
vote
1answer
528 views

Improved MySQL interface

Is there a MySQL terminal prompt that supports things like tab-completion and history? The standard one that comes with MySQL doesn't have those features
1
vote
1answer
66 views

can't connect to mysql as admin from outside

I have a dedicated server (CentOS 5.3) but I can't log on to mysql as admin from outside, however I can do that when I'm on server's command line. I assume there's a setting somewhere that can give me ...
2
votes
2answers
1k views

Postfix cannot find a MySQL shared library

I am trying to install Postfix with MySQL support. When I start or run the postfix daemon, it complains that it "cannot find libmysqlclient.so.18", which is in the directory /usr/local/mysql/lib, ...
1
vote
1answer
878 views

Trouble installing MySQL from binaries

So, I am a freshman in Computer Science, and I have dug an old computer out of my garage to use as a personal hosting server for various services (email, web site, subversion, etc.), partly because I ...
2
votes
1answer
1k views

Mysql / swap space full

I have MySQL Ver 14.12 Distrib 5.0.45 server running on Multiflex Intel Blade having 8G of RAM & 8 x Intel(R) Xeon(R) CPU E5410 @ 2.33GHz. The problems I am facing are: For the last 3-4 days ...
5
votes
4answers
2k views

Selinux is denying access to mysqld

I have a script that dumps a mysql database. It then compresses the file and this gets stored in my home folder by using cron. The problem is I seem to be getting an error message. mysqldump: ...
2
votes
1answer
402 views

How to install a database dump via Shell Script?

I have a Mysql database dump. I want to install it with Hudson via a Shell Script to an external Linux machine. How can you take a Mysql script and run it inside a database on other machine? I know I ...
0
votes
2answers
266 views

Linux (Debian) web server advice

I'm at the start of a new company in which the main activity is building internet web apps. I was very familiar with linux 8-9 years ago, but since then, I've lost a lot of touch with it (couldn't ...
-1
votes
1answer
9k views

Should the mysql user have access to /var/lib/mysql?

First, let me say that mysql seems to be working perfectly on the machine. Still, when I su mysql and ls /var/lib/mysql, I get access denided. When I sudo ls /var/lib/mysql I see the data files ...
0
votes
2answers
251 views

Installing MySQL 5.5 on Mac OS 10.6

I am trying to install MySQL from source on my Mac OS. I've expanded the source code, and am now trying to configure it. However, I can't get past that step: ...
2
votes
2answers
1k views

SFTP with Mysql user pass instead of PAM

Is there a way for people to log onto a debian server via sftp using just mysql database table as authentaction. IE not adding a user to the system? I know it can be done over ftp and TLS but i ...
1
vote
1answer
2k views

Install MySQL workbench on ubuntu

I am using Ubuntu 9.10 - the Karmic Koala - released in October 2009 I downloaded mysql-workbench-gpl-5.2.33b-1ubu1004-i386.deb from here But when I run this package it show me following error: ...
0
votes
1answer
511 views

How to write script for automatic joomla installation in webhost

I want to create a script in Linux that automatically downloads the latest Joomla from their website and then installs it to the specified user. Is it possible in a shell script? I don't know how it ...
1
vote
1answer
659 views

crypt() on different machines

Because of a hardware issue i need to migrate many virtual users to a new machine. Their passwords stored in MySQL encrypted with ENCRYPT which using crypt()eventually. Maybe it's my fault but salt ...
5
votes
2answers
3k views

Hight iowait while the wMB/s is low

I was indexing a MySQL table. It makes a high load on that computer. It seems due to a high iowait. But it also shows that the wMB/s is only 2.87. Isn't even a common SATA HDD able to handle more ...
2
votes
1answer
1k views

Install MySQL from Bash Script

I'm coding a bash script to automate the process of deploying VPS servers but I'm having some trouble while trying to install MySQL from either aptitude/apt-get or yum, this is what I have so far: if ...
1
vote
4answers
535 views

Multiple Mysql databases backup tool?

My OS is Ubuntu 10.10. I have several small sites (all on various shared hosts) and I'm thinking that it'd be probably good idea to regularly backup mysql databases from these remote shared hosts. I ...
5
votes
1answer
1k views

Batch importing .sql files

I have a bunch of .sql files in a directory that I need to import. Although I can do it manually, for scripting purposes I need to be able to apply them in bulk. How can I do that though? What ...
2
votes
1answer
236 views

Bash script and Database

I have an iptables firewall in Linux bridge (RHEL5). I want to extract information like IP address, port number, port type, date and time, etc. from log messages using a Bash script, and then want to ...