In the process of creating an automated solution for backing up and restoring an entire MySQL server, I've come across the mysql database which seems to contain user accounts, permissions, metadata, that kind of thing. Should this database be backed up? Will backing up and attempting to restore it break things?
I've had a heck of a time Googling for "mysql backing up mysql database" as you can imagine.
If you disable the keys (suspending indexing) on a mysql INNODB table, how long does that setting last?
For a query like:
ALTER TABLE users DISABLE KEYS;
Do the keys get re-enabled at the end of the script? or do they last until you explicitly turn indexing back on?
I have a MySQL table that has a number of columns with the latin1 character set. Because of driver issues, the columns actually contain utf8 data. I want to leave the data as-is but change the column character set to UTF8.
Every solution I've examined does two alter table commands, changing the column to binary, then back to the previous type with the new character set.
There are multiple columns on multiple tables in multiple databases, so this approach would be pretty slow.
Is there a better way to get this done?
Often I end up doing server administration for clients as part of developing web applications, I always set up access for myself using an SSH Key pair. I usually end up choosing a random password for the root account and emailing that to my clients. The client sometimes doesn't even need to have access, I just want to make sure and not be the only one holding the keys in case I'm not available, or they switch to another developer.
For non-technical clients, what is the best way to manage, store, and communicate important passwords and credentials?
Personally, I use Lastpass, but requesting a client to signup to share one password which can't be used via the browser seems a little off.
Possible Duplicate:
Can you help me with my software licensing question?
I'm a developer and while working on a project a question came up about licensing.
The web application I'm working on will be closed source and we are looking at a few different hosting providers. Are commercial licenses required for using software released under GPL (i.e MySQL)? Or does the hosting provider take care of that?
I have several RewriteRules in an Apache VirtualHost configuration. I'd like to be able to test the current URL (after the preceeding rewrites) against some condition. The problem is that the variable %REQUEST_URI is set at the beginning of processing and doesn't change after every rule. There is very little documentation on those variables; is there is some way to use RewriteCond to test against the current URL?
I've enabled the rewrite log and it's apparent that even after the first RewriteRule is matched and re-written, %REQUEST_URI is still set to '/'
#Map '/' and '' to '/home'
RewriteRule ^/?$ /home
#Check for cached page
RewriteCond %{DOCUMENT_ROOT}/system/cache%{REQUEST_URI}.html -f
RewriteRule ^(.+)$ /system/cache/$1.html [QSA,L]
Is there any simple way to accomplish this?
Edit: Here is an excerpt from the RewriteLog, I don't think an internal sub-request is happening.
(3) applying pattern '^/?$' to uri '/'
(2) rewrite '/' -> '/home'
(3) applying pattern '^([^.]+)$' to uri '/home'
(4) RewriteCond: input='/var/www/vhosts/example.com/subdomains/demo/rails/public/system/cache/.html' pattern='-f' => not-matched
(3) applying pattern '^.*$' to uri '/home'
(4) RewriteCond: input='/var/www/vhosts/example.com/subdomains/demo/rails/public/system/maintenance.html' pattern='-f' => not-matched
(3) applying pattern '^/(.*)$' to uri '/home'
(4) RewriteCond: input='/home' pattern='!-f' => matched
(2) rewrite '/home' -> 'http://127.0.0.1:8100/home'
(2) forcing proxy-throughput with http://127.0.0.1:8100/home
(1) go-ahead with proxy request proxy:http://127.0.0.1:8100/home [OK]