We’re rewarding the question askers & reputations are being recalculated! Read more.

Questions tagged [mysql]

An open-source, relational database management system.

Filter by
Sorted by
Tagged with
3
votes
1answer
5k 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
547 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?
1
vote
3answers
2k 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
1answer
463 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
453 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 the ...
1
vote
1answer
597 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
8
votes
1answer
12k 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 /etc/...
2
votes
2answers
3k 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, ...
2
votes
1answer
2k 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 my ...
1
vote
1answer
94 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
1answer
682 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
1answer
671 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 ...
2
votes
1answer
697 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 ...
2
votes
1answer
2k 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 ...
5
votes
1answer
2k 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
254 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 ...