Pour imprimer en un seul fichier PDF la totalité du workbook il faut bien prendre garde que dans le Page setup de chaque feuille le First Page number est à auto, car si l'on spécifie un numéro de page qui n'est pas dans la continuité des pages précédentes, la feuille est imprimée dans un fichier PDF à part.
property commandString : "ssh user@host" -- < Edit this line as desired.
tell application "Terminal" -- Get a free window to run the commandString,
set windowCount to (count of the windows)
--activate
if ((count of windows) is 1) then
close window 1 -- attention, s'il n'y a qu'une seule fenêtre ouverte, elle sera fermée
--tell window 1
-- set miniaturized to true
--end tell
repeat with w from 1 to 3 -- je veux 3 connexions
tell window (windowCount + 1)
do script commandString
end tell
tell application "Terminal" to set current settings of first window to settings set 7
--settings 7 = my colors and ISO-8859-1ISO Latin-1 encoding and police 16 pt
tell front window
set zoomed to true
-- Je veux que mes 3 fenêtres soient maximizées et occupent tout l'écran
end tell
end repeat
else
repeat with w from 1 to 3
tell window (windowCount + 1)
do script commandString
end tell
tell application "Terminal" to set current settings of first window to settings set 7
tell front window
set zoomed to true
end tell
end repeat
end if
end tell
*** Autre version, avec trois fenêtres disposées 1 full screen et 2 half screen ***
pour un écran de 1680 x 1050
property commandString : "ssh meteo@mars" -- < Edit this line as desired.
tell application "Terminal" -- Get a free window to run the commandString,
set windowCount to (count of the windows)
activate
if ((count of windows) is 1) then
close window 1
--tell window 1
-- set miniaturized to true
--end tell
repeat with w from 1 to 3
tell window (windowCount + 1)
do script commandString
end tell
tell application "Terminal" to set current settings of first window to settings set 7
tell front window
if w is 1 then
set zoomed to true
else
if w is 2 then
set position to {20, 22}
set size to {825, 960}
--properties
--tell application "Terminal" to set bounds of first window to {0, 0, 820, 975}
else
set position to {850, 22}
set size to {825, 960}
--properties
--tell application "Terminal" to set bounds of first window to {0, 670, 820, 975}
end if
end if
end tell
end repeat
else
repeat with w from 1 to 3
tell window (windowCount + 1)
do script commandString
end tell
tell application "Terminal" to set current settings of first window to settings set 7
tell front window
if w is 1 then
set zoomed to true
else
if w is 2 then
set position to {20, 22}
set size to {825, 960}
--properties
--tell application "Terminal" to set bounds of first window to {0, 0, 820, 975}
else
set position to {850, 22}
set size to {825, 960}
--properties
--tell application "Terminal" to set bounds of first window to {0, 670, 820, 975}
end if
end if
end tell
end repeat
end if
end tell
to disable the plugin
completely, you can use the command
let loaded_matchparen = 1
in your ~/.vimrc
To turn it off
:NoMatchParen
To turn it back on
:DoMatchParen
Pour donner accès aux dB à un utilisateur :
Se logger comme root dans mysql
mysql -u root mysql -p
au prompt : password
puis
GRANT ALL PRIVILEGES ON *.* TO 'username'@'localhost' IDENTIFIED BY '' WITH GRANT OPTION;
flush privileges;
Pour vérifier :
SELECT user, host, password FROM user;
à la place de localhost = connection uniquement en local, on peut mettre % pour pouvoir se logger à distance.Les fichiers des db se trouvent (ubuntu 8.04)
/var/lib/mysql/
On peut simplement faire une copie des fichiers mais il faut mettre un lock write avant.
C'est ce que fait le script mysqlhotcopy
Syntaxe :
A exécuter comme root
mysqlhotcopy metar_2009 -u meteo -p '' --addtodest /tmp/mysqlbackup
mysqlhotcopy db_name_1 ... db_name_n /path/to/new_directory
--addtodest
Do not rename target directory (if it exists); merely add files to it.
--dryrun, -n
Report actions without performing them.
--method=command
The method for copying files (cp or scp).
--password=password, -ppassword
The password to use when connecting to the server. Note that the password value is not optional for this option, unlike for other MySQL programs. You can use an option file to avoid giving the password on the command line.
--user=user_name, -u user_name
The MySQL user name to use when connecting to the server.
6.1. Database Backups
This section summarizes some general methods for making backups.
Making Backups by Copying Files
MyISAM tables are stored as files, so it is easy to do a backup by copying files. To get a consistent backup, do aLOCK TABLES on the relevant tables, followed by FLUSH TABLES for the tables. See Section 12.4.5, “LOCK TABLES and UNLOCK TABLES Syntax”, and Section 12.5.6.3, “FLUSH Syntax”. You need only a read lock; this allows other clients to continue to query the tables while you are making a copy of the files in the database directory. The FLUSH TABLES statement is needed to ensure that the all active index pages are written to disk before you start the backup.
Making Delimited-Text File Backups
To create a text file containing a table's data, you can use SELECT * INTO OUTFILE '. The file is created on the MySQL server host, not the client host. For this statement, the output file cannot already exist because allowing files to be overwritten would constitute a security risk. See Section 12.2.8, “file_name' FROMtbl_nameSELECT Syntax”. This method works for any kind of data file, but saves only table data, not the table structure.
To reload the output file, use LOAD DATA INFILE or mysqlimport.
Making Backups with mysqldump or mysqlhotcopy
Another technique for backing up a database is to use the mysqldump program or the mysqlhotcopy script.mysqldump is more general because it can back up all kinds of tables. mysqlhotcopy works only with some storage engines. (See Section 4.5.4, “mysqldump — A Database Backup Program”, and Section 4.6.9, “mysqlhotcopy — A Database Backup Program”.)
Create a full backup of your database:
shell> mysqldump --tab=/path/to/some/dir --opt db_name
Or:
shell> mysqlhotcopy db_name /path/to/some/dir
You can also create a binary backup simply by copying all table files (*.frm, *.MYD, and *.MYI files), as long as the server isn't updating anything. The mysqlhotcopy script uses this method. (But note that these methods do not work if your database contains InnoDB tables. InnoDB does not necessarily store table contents in database directories, and mysqlhotcopy works only for MyISAM and ISAM tables.)
For InnoDB tables, it is possible to perform an online backup that takes no locks on tables; see Section 4.5.4, “mysqldump — A Database Backup Program”.
strftime('%w',unixtime,'unixepoch','localtime')
Avec mysql la commande équivalente est :
FROM_UNIXTIME(unixtime,'%w')
Pas besoin de préciser localtime, car la conversion se fait directement selon le timezone (par défaut SYSTEM)
FROM_UNIXTIME(, unix_timestamp)FROM_UNIXTIME(unix_timestamp,format)
Returns a representation of the unix_timestamp argument as a value in 'YYYY-MM-DD HH:MM:SS' orYYYYMMDDHHMMSS.uuuuuu format, depending on whether the function is used in a string or numeric context. The value is expressed in the current time zone. unix_timestamp is an internal timestamp value such as is produced by the UNIX_TIMESTAMP() function.
If format is given, the result is formatted according to the format string, which is used the same way as listed in the entry for the DATE_FORMAT() function.
mysql>SELECT FROM_UNIXTIME(1196440219);-> '2007-11-30 10:30:19' mysql>SELECT FROM_UNIXTIME(1196440219) + 0;-> 20071130103019.000000 mysql>SELECT FROM_UNIXTIME(UNIX_TIMESTAMP(),->'%Y %D %M %h:%i:%s %x');-> '2007 30th November 10:30:59 2007'
Note: If you use UNIX_TIMESTAMP() and FROM_UNIXTIME() to convert between TIMESTAMP values and Unix timestamp values, the conversion is lossy because the mapping is not one-to-one in both directions. For details, see the description of the UNIX_TIMESTAMP() function.
Formats the date value according to the format string.
The following specifiers may be used in the format string. The “%” character is required before format specifier characters.
| Specifier | Description |
%a |
Abbreviated weekday name (Sun..Sat) |
%b |
Abbreviated month name (Jan..Dec) |
%c |
Month, numeric (0..12) |
%D |
Day of the month with English suffix (0th, 1st, 2nd, 3rd, …) |
%d |
Day of the month, numeric (00..31) |
%e |
Day of the month, numeric (0..31) |
%f |
Microseconds (000000..999999) |
%H |
Hour (00..23) |
%h |
Hour (01..12) |
%I |
Hour (01..12) |
%i |
Minutes, numeric (00..59) |
%j |
Day of year (001..366) |
%k |
Hour (0..23) |
%l |
Hour (1..12) |
%M |
Month name (January..December) |
%m |
Month, numeric (00..12) |
%p |
AM or PM |
%r |
Time, 12-hour (hh:mm:ss followed by AM or PM) |
%S |
Seconds (00..59) |
%s |
Seconds (00..59) |
%T |
Time, 24-hour (hh:mm:ss) |
%U |
Week (00..53), where Sunday is the first day of the week |
%u |
Week (00..53), where Monday is the first day of the week |
%V |
Week (01..53), where Sunday is the first day of the week; used with %X |
%v |
Week (01..53), where Monday is the first day of the week; used with %x |
%W |
Weekday name (Sunday..Saturday) |
%w |
Day of the week (0=Sunday..6=Saturday) |
%X |
Year for the week where Sunday is the first day of the week, numeric, four digits; used with %V |
%x |
Year for the week, where Monday is the first day of the week, numeric, four digits; used with %v |
%Y |
Year, numeric, four digits |
%y |
Year, numeric (two digits) |
%% |
A literal “%” character |
% |
x, for any “x” not listed above |
Ranges for the month and day specifiers begin with zero due to the fact that MySQL allows the storing of incomplete dates such as '2014-00-00'.
The language used for day and month names and abbreviations is controlled by the value of the lc_time_namessystem variable (Section 9.8, “MySQL Server Locale Support”).
DATE_FORMAT() returns a string with a character set and collation given by character_set_connection andcollation_connection so that it can return month and weekday names containing non-ASCII characters.
mysql>SELECT DATE_FORMAT('2009-10-04 22:23:00', '%W %M %Y');-> 'Sunday October 2009' mysql>SELECT DATE_FORMAT('2007-10-04 22:23:00', '%H:%i:%s');-> '22:23:00' mysql>SELECT DATE_FORMAT('1900-10-04 22:23:00',->'%D %y %a %d %m %b %j');-> '4th 00 Thu 04 10 Oct 277' mysql>SELECT DATE_FORMAT('1997-10-04 22:23:00',->'%H %k %I %r %T %S %w');-> '22 22 10 10:23:00 PM 22:23:00 00 6' mysql>SELECT DATE_FORMAT('1999-01-01', '%X %V');-> '1998 52' mysql>SELECT DATE_FORMAT('2006-06-00', '%d');-> '00'