mysql-5 : Version of MySQL Starting with MySQL 5.0

learn more… | top users | synonyms

1
vote
3answers
33 views

Show All Results From One Table Not Listed In The Other (Junction) Table By :id

I have 2 tables I'm interacting with. The first table: acl_permissions (is just a normal table). +-----------------------------------+ | acl_permissions | ...
0
votes
1answer
20 views

Can't start mysql server after macports installation

150213 16:12:31 mysqld_safe mysqld from pid file /opt/local/var/[hostname].local.pid ended 150213 16:21:09 mysqld_safe Starting mysqld daemon with databases from /opt/local/var 150213 16:21:09 ...
0
votes
1answer
28 views

How to backup MySQL databases when the MySQL server is off?

My MySQL server does not start, as according to the guides I found over the internet, the best solution is to re-install MySQL server (with apt-get purge). However, this process will delete my ...
0
votes
1answer
280 views

Ubuntu 10.04 to 12.04, mysql5 causes upgrade hang

I'm doing a release update from 10.04 to 12.04. The upgrade process walked me through all the conflicting .conf files and I chose to keep my version of mysql.conf. Despite that, the upgrade process is ...
0
votes
1answer
243 views

Why does rsnapshot not back up /var/lib/mysql/*?

In rsnapshot's config file I added /var/lib/mysql/ as another source directory to back up. But rsnapshot does not back it up. Why? /var/log/rsnapshot does not list a relevant warning. The owner of ...
2
votes
0answers
382 views

Who should I run mysql as, on a personal computer?

I just installed mysql via homebrew (with brew install mysql, on Mac OS X Mountain Lion - recently installed from scratch). Following the installation, there is a "caveats" section with options around ...
1
vote
0answers
154 views

After logging into MySQL 5.6 successfully as root, it says access denied for root, ERROR 1045 (28000)

I recently used MacPorts to upgrade from MySQL 5.5 to 5.6. I can use my database fine on my laptop. I tried to enable remote access to the database so I could edit the database using DB clients on ...
0
votes
0answers
78 views

Access MySQL running on VirtualBox Win7 guest from a VirtualBox XP guest

I have a Windows 7 host, and 2 VirtualBox guest machines running on it. One has Windows7 as well and running a MySQL 5.6 server. The other guest has Windows XP. I want to run a software (for testing ...
0
votes
0answers
604 views

Raspberry Pi: mvoe home & var folders to USB HDD?

I have a Raspberry Pi running raspian. I've installed Apache2, PHP & MySQL. Apache & MySQL are both configured to use sub-directories of /var. I'd like to use a directory on my USB HDD ...
0
votes
0answers
61 views

Configuring the mysql server

I have a mysql server installed in RHEL 6 system with 128 GB of Ram and 16 Cores. i am running 4 websites with quite heavy queries having big joins and sortings. Please suggest me a good configuration ...