Tagged Questions
5
votes
1answer
590 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 ...
3
votes
1answer
4k 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
268 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 ...
2
votes
0answers
636 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
4answers
464 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 ...
1
vote
4answers
502 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 ...
1
vote
2answers
668 views
MySQL not getting started on linux
I need to run MySQL service for my linux 2.16 version with SUSE version 11 distribution.
Downloaded the following files and installed all the rpms as under:
MySQL-server-5.5.27-1.sles11.i586
...
1
vote
1answer
49 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 ...
1
vote
1answer
269 views
AutoMysqlBackup --lock-tables=false
I'm trying to use AutoMysqlBackup script to perform daily backups of my application.
Unfortunately on the first try it didn't served me how I thought it would.
I believe that the script has used the ...
1
vote
1answer
431 views
update mysql on debian
I'm trying to update Mysql on debian without success, and all tutorial on internet just fails.
I got Debian 6.0.6 squeeze, my mysql version is mysql Ver 14.14 Distrib 5.1.63.
I did apt-get update and ...
1
vote
0answers
118 views
Force mysqldump encoding
I have two mysql servers, viewed from the same mysql client, right_server is rendering the french characters correctly, wrong_server is not. Encoding is the same :
$ mysql -h right_server -NBe "SHOW ...
0
votes
2answers
274 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?
0
votes
2answers
304 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 ...
0
votes
1answer
57 views
Connecting from OpenVPN Server to MySQL Server
I have an OpenVPN server installed on a server. What I'm trying to do connect from the OpenVPN server using the mysql client to the MySQL server than is connected to the OpenVPN server using a ...
0
votes
2answers
179 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 ...
