Fulltext results:

Travian Map Download Script @z:travian

38 Hits, Last modified: 12 years ago

is is my script(s) which I use to downoad the map.sql from Travian and import it to the database. ====... n DUMP_DIR=/srv/glassfish/domains/domain1/docroot/sql # # executables MYSQL="/srv/mysql/bin/mysql --default-character-set=utf8 -u${DB_USER} -p${DB_PASS} ${DB_INST}" MYSQLDUMP="/s

MySQL: Change Password @info:mysql:user

6 Hits, Last modified: 11 years ago

====== MySQL: Change Password ====== * Replace ''{passwd}'' with the password of the user. * Replace ''{user}'' with the name of the user. <code sql> GRANT USAGE ON *.* TO '{user}'@'%' IDENTIFIED BY... r you can alternatively use the following: <code sql> UPDATE mysql.user SET Password=PASSWORD('{passwd}') WHERE User='{user}'; FLUSH PRIVILEGES; </code> {

MySQL: Create User @info:mysql:user

6 Hits, Last modified: 9 years ago

====== MySQL: Create User ====== ==== Create User ==== <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}... ==== * Usually, ''{user}'' == ''{db}'' <code sql> CREATE USER '{user}'@'%' IDENTIFIED BY '{passwd}... {user}'@'%'; </code> Simpler Alternative: <code sql> CREATE DATABASE IF NOT EXISTS `dbname` DEFAULT C

MySQL: Backup @info:mysql:database

6 Hits, Last modified: 12 years ago

====== MySQL: Backup ====== ===== Export a Database ===== <code bash> # set or replace the variables ... $PASS DATE_YMD=$(date "+%Y-%m-%d") DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases') for db in ${DATABASES} do mysqldump ... ble -u${USER} -p${PASS} ${DB} > ${DB}_${DATE_YMD}.sql & bzip2 ${DB}_${DATE_YMD}.sql & # sleep 1

Formatting Syntax @wiki

5 Hits, Last modified: 4 years ago

post mirc mk-61 mmix modula2 modula3 mpasm mxml mysql nagios netrexx newlisp nginx nimrod nsis oberon2 ... f phix php-brief php pic16 pike pixelbender pli plsql postgresql postscript povray powerbuilder powershell proftpd progress prolog properties providex pureb... scilab scl sdlbasic smalltalk smarty spark sparql sql sshconfig standardml stonescript swift systemveri

MySQL: Remove User @info:mysql:user

5 Hits, Last modified: 12 years ago

====== MySQL: Remove User ====== ==== Remove User ==== <code sql> DROP USER '{user}'@'%'; </code> ==== Remove Use... Database ==== * Usually, {user} == {db} <code sql> DROP USER '{user}'@'%'; DROP DATABASE '{db}'; </code> {{tag>admin database mysql sql}}

MySQL: Create Database @info:mysql:database

5 Hits, Last modified: 12 years ago

====== MySQL: Create Database ====== ==== Create Database ==== <code sql> CREATE DATABASE IF NOT EXISTS `{db}`; </code> =... e Database and Grant Rights to a User ==== <code sql> CREATE DATABASE IF NOT EXISTS `{db}`; GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}

Oracle: SPFile and PFiles @info:oracle

4 Hits, Last modified: 12 years ago

File, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will creat... to the PFile instead of ${PATH_TO_PFILE}. <code sql> SHUTDOWN IMMEDIATE; STARTUP NOMOUNT PFILE='${PAT... itweb.ora'', the the second line would be: <code sql> STARTUP NOMOUNT PFILE='/db/oracle/config/pfiles/... he init param in memory and in the SPFile. <code sql> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=8G S

MySQL: Revoke Permissions @info:mysql:permissions

4 Hits, Last modified: 12 years ago

====== MySQL: Revoke Permissions ====== ==== Revoke Permissions ==== <code sql> REVOKE ALL PRIVILEGES ON `{db}` . * FROM '{user}'@'%'; </code> {{tag>admin database mysql sql}}

MySQL: Grant Permissions @info:mysql:permissions

4 Hits, Last modified: 12 years ago

====== MySQL: Grant Permissions ====== ==== Grant Permissions ==== <code sql> GRANT ALL PRIVILEGES ON `{db}` . * TO '{user}'@'%'; </code> {{tag>admin database mysql sql}}

MySQL: View Permissions @info:mysql:permissions

4 Hits, Last modified: 12 years ago

====== MySQL: View Permissions ====== ==== View Permissions ==== <code sql> SHOW PRIVILEGES; SHOW GRANTS FOR '{user}'@'%'; </code> {{tag>admin database mysql sql}}

MySQL: Remove Database @info:mysql:database

4 Hits, Last modified: 12 years ago

====== MySQL: Remove Database ====== ==== Remove Database ==== <code sql> DROP DATABASE IF EXISTS `{db}`; </code> {{tag>admin database mysql sql}}

mysql @tag

3 Hits, Last modified: 11 years ago

====== mysql ====== ===== Pages ===== {{topic>mysql&nouser&tags}} ===== Bookmarks ===== {{rss>http://www.andunix.net/link/rss/all/mysql}}

Oracle: List Accounts with Objects @info:oracle

3 Hits, Last modified: 12 years ago

ts (like tables), you can query them with: <code sql> SELECT DISTINCT OWNER FROM DBA_OBJECTS ORDER BY ... ist all accounts, you can query them with: <code sql> SELECT USERNAME FROM ALL_USERS ORDER BY USERNAME; </code> Or, if you only want the DBAs: <code sql> SELECT USERNAME FROM DBA_USERS ORDER BY USERNAME

sql @tag

3 Hits, Last modified: 11 years ago

====== sql ====== ===== Pages ===== {{topic>sql&nouser&tags}} ===== Bookmarks ===== {{rss>http://www.andunix.net/link/rss/all/sql}}

Oracle: Resize Instance @info:oracle

3 Hits, Last modified: 12 years ago

Oracle: Recovery Manager @info:oracle

2 Hits, Last modified: 12 years ago

Home Server Goals @blog:2010

2 Hits, Last modified: 9 years ago

Oracle: SQLplus Scripting @info:oracle

1 Hits, Last modified: 12 years ago

MySQL @info:mysql

1 Hits, Last modified: 12 years ago