By default mysqldump backup triggers but not stored procedures. For that you must add the
But how do you do to dump only triggers and stored procedures ?
Like this :
mysqldump --routines --no-create-info --no-data --no-create-db --skip-opt <database> > <dump>.sql
mysqldump make a dump with only one INSERT statement per table. This is efficient but annoying as hell when you need to debug a failed import.
In that case i recommend you to redump the problematic database with the option
--extended-insert=FALSE to get a dump with one INSERT statement for each data row.
GNU Screen have a very useful feature: sharing the same same session with multiple terminals.
Setting up a shared screen session
The following command sequence sets up a shared screen session named ‘shared’:
screen -d -m -S shared
Listing screen sessions
There is a screen on:
1 Socket in /var/run/screen/S-pkb.
Attaching an existing session
screen -x shared
Doing the same… with different users
First the bad news : screen sharing with another account requires that the screen command be suid root. That a strong security risk so do it only if you are on a non-critical environment. When it’s done, simply start a new session as usual, then:
Enable multiuser support
Add the user to join your session
Now the user
foobar can join the session
shared launched by the user
user like this
screen -x user/shared.
When adding a new domain name to an eZPublish website, the
site.ini file must be modify to assign the domain to an existing siteaccess.
Simply add a new entry into the HostMatchMapItems array: