An open-source, relational database management system.
1
vote
1answer
15 views
Import sql files using xargs
I have a number of sql files to import. For a single file I use the following command:
mysql -u root -p dbname < db.sql
Is it possible to use xargs to bulk import all files? something like:
ls ...
0
votes
1answer
33 views
Debian Squeeze/MySQL error
I am a Unix/Linux noob, so please bear with me.
I installed lighttpd and PHP on MySQL using the instructions in the accepted answer here:
...
2
votes
2answers
86 views
Building MariaDB 5.5.27 without OQGraph: How to deselect the plugin?
I'm trying to build MariaDB 5.5.27 from source. In fact, I just need the client, but I seem to have to build the complete database system anyway.
While configuring with cmake and later compiling with ...
1
vote
1answer
83 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 ...
2
votes
2answers
75 views
MySQL Linux Client Timeout/Keepalive
Is there a way to set a keepalive in the command-line MySQL client on Linux?
Our network recently moved to a VLAN setup, and our systems department no longer has control of the firewall. The ...
3
votes
2answers
72 views
MySQL 5.1 to 5.5: all UTF-8 characters lost!
I decided to upgrade my Debian installation, and after some days using MySQL 5.5, I found that mysql prints garbage to the terminal intead of UTF-8 characters.
I had a look at the SQL file that was ...
6
votes
1answer
49 views
/etc/passwd sql with bash access
I just got a CentOS VPS and was reviewing the passwd file and saw this:
mysql:x:498:499:MySQL server:/var/lib/mysql:/bin/bash
Is bash necessary for mysql?
1
vote
1answer
33 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
2answers
85 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
2answers
72 views
Getting error 2006 MySQL server has gone away on CentOS
I need to import a database into a freshly created CentOS 5 virtual machine. However, whenever I run the import command on the console, it stops working in about a minute and I get the error message:
...
0
votes
0answers
6 views
Getting error 2006 MySQL server has gone away on CentOS [closed]
Possible Duplicate:
Getting error 2006 MySQL server has gone away on CentOS
I need to import a database into a freshly created CentOS 5 virtual machine. However, whenever I run the import ...
1
vote
1answer
103 views
Import single rows from SQLite to MySQL?
I need to do some kind of incremental import again and again from a SQLite 3 database to a MySQL database. Column names are the same in both databases. Is there a good way to do this by a script ...
1
vote
2answers
46 views
How do I set the mysql server character set in FreeBSD 8.2?
My mysql server's current server character set is latin1. My server is started on startup via rc.conf setting mysql_enable="YES". How to set my server to use utf8 as the server character set?
0
votes
0answers
44 views
DP: Apache Web Server character encoding [closed]
I'm double posting because I think U guyz may have a clue:
http://serverfault.com/questions/423663/apache-web-server-character-encoding
10x
0
votes
1answer
74 views
Force users to change email password every six months
I'm going to build an experimental mail server with Postfix + Dovecot and Mysql for user accounts.
The server will offer SMTP + POP3 + IMAP.
Is there a way to force users to change their mail account ...
