Fulltext results:

Travian Map Download Script @z:travian

41 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: Backup @info:mysql:database

8 Hits, Last modified: 12 years ago

====== MySQL: Backup ====== ===== Export a Database ===== <code bash> # set or replace the variables $USER, $PASS and $DB mysqldump --add-drop-table -u${USER} -p${PASS} ${DB} </... $PASS DATE_YMD=$(date "+%Y-%m-%d") DATABASES=$(mysql --batch -u${USER} -p${PASS} mysql --execute='show databases') for db in ${DATABASES} do mysqldump

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

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

Oracle: SPFile and PFiles @info:oracle

5 Hits, Last modified: 12 years ago

e SPFiles to a PFile, just enter the following in SQLplus: <code sql> CREATE PFILE FROM SPFILE; </code> It will create a PFile ''${ORACLE_HOME}/dbs/init${... 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/

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}}

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}}

Oracle: List Accounts with Objects @info:oracle

4 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; </code> {{tag>admin oracle sqlplus}}

Oracle: SQLplus Scripting @info:oracle

4 Hits, Last modified: 12 years ago

====== Oracle: SQLplus Scripting ====== To show only data in SQLplus and no header or other stuff, enter the following: <code sql> SET NEWPAGE 0 SET SPACE 0 SET LINESIZE 80 SET PA... SET VERIFY OFF SET HEADING OFF SET MARKUP HTML OFF SPOOL OFF </code> {{tag>oracle scripting sqlplus}}

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: 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: 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: 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}}

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

mysql @tag

3 Hits, Last modified: 11 years ago

sqlplus @tag

3 Hits, Last modified: 11 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

Firefox Extensions @info:prog:firefox

2 Hits, Last modified: 11 years ago

MySQL @info:mysql

1 Hits, Last modified: 12 years ago