Redirect stderr from mysqldump as well. Use &> instead of just >
Thanks! I did just that, and got the following error (which, allow me to preface, I've been having similar errors trying to make a small test site on my server of Drupal)
But I don't understand - I'm using the same username/password and database as my wordpress install, I even copy/pasted the syntax of it out of the wp-config.php file, so I don't know what I'm mistyping
Hello everyone!
First I would like to say that I am very glad that I found this forum, and by some of the posts I have viewed, I see that I can learn a lot from you all!
Secondly, I know next to nothing about Linux/Unix (gotta learn sometime right?) and need some assistance.
I am a... (5 Replies)
how do i install php & mysql with apache on suse linux ???
apache was installed and configured when i installed linux.
all its files are in different folders. e.g http files in usr/local/httpd/htdocs/ and its configs are in etc/httpd/
so how do i install php and get it to work with apache and... (4 Replies)
How do i get php to sort the times in a table and print order desending. eg:
in the table i have: 02:60.00
02:70.00
02:20.00
02:50.00
in that order in a table
how do i get php & mysql to print... (1 Reply)
Hi all,
I want to restore DB file in many mysql servers, i already using script for sending the dumpfile in all servers, but it's just annoying if i have to restore the dumpfile in all servers, i want just execute 1 script, and will restore in all remote mysql servers. I make script but not... (2 Replies)
Hi folks
I have mysql dump which having insert queries, i want to break that file when 10 complete "INSERTS" lines so extract that line and store in 1.sql and 2.sql and for next 10 insert lines.
pls guide me how can i do that.
Regards,
Bash (2 Replies)
Hi all,
What I was looking for before was a multi-user password manager, web-based! The offer of free or cheap tools of this kind is very pover. Or they are too complex (or too expensive)
I'm not a web programmer but I now decided to set up a (php) website with login and based on this login... (1 Reply)
Hi, I hope the title does not scare people to look into this thread but it describes roughly what I'm trying to do. I need a solution in PHP.
I'm a programming beginner, so it might be that the approach to solve this, might be easier to solve with an other approach of someone else, so if you... (0 Replies)
I have a script (below) which works ok, but I have tried to modify it as I want to keep the older files for a restore if needed. I have tried adding a date suffix to the newly created files (second lump of code), but it doesn't seem to work.
I get the error:
$SOURCEDIR/p1db_$DATEVAR.sql:... (3 Replies)
Hi, i have the following:
db="create database xxx;GRANT ALL PRIVILEGES ON xxx.* TO user@localhost IDENTIFIED BY 'password';FLUSH PRIVILEGES;quit;"
mysql -u root -p$mysql_pass -e "$db"
I don't understand why this is failing, it works fine when run from cmd but when is run in a bash script,... (1 Reply)
Discussion started by: ktm
1 Replies
LEARN ABOUT DEBIAN
drush
DRUSH(1) General Commands Manual DRUSH(1)NAME
drush - shell scripting interface for Drupal
SYNOPSIS
drush [options] command...
DESCRIPTION
drush is a veritable Swiss Army knife designed to make life easier for those of us who spend some of our working hours hacking away at the
command prompt.
Drush core ships with lots of useful commands for interacting with code like modules/themes/profiles. Similarly, it runs update.php, exe-
cutes sql queries and DB migrations, and misc utilities like run cron or clear cache.
OPTIONS -r path, --root=path
Drupal root directory to use (default: current directory)
-l uri, --uri=uri
URI of the drupal site to use (only needed in multisite environments)
-v, --verbose
Display extra information about the command.
-q, --quiet
Hide all output
-d, --debug
Display even more information, including internal messages.
-y, --yes
Assume 'yes' as answer to all prompts
-s, --simulate
Simulate all relevant actions (don't actually change the system)
-p, --pipe
Emit a compact representation of the command for scripting.
-h, --help
A detailed help system, use drush help help for complete help.
--version
Show drush version.
If you get tired of typing options all the time, you can add them to your drush.php alias or create a drushrc.php file. These provide addi-
tional options for your drush call. They provide great flexibility for a multi-site installation, for example. See example.drushrc.php.
COMMANDS
Drush is all based around "commands" that are usually defined in various modules.
help Print the help message. Use --filter to limit command list to one command file (e.g. --filter=pm).
cache-clear (cc)
Clear a specific cache, or all drupal caches.
core-cli (cli)
Enter a new shell optimized for Drush use.
core-cron (cron)
Run all cron hooks.
core-status (st)
Provides a birds-eye view of the current Drupal installation, if any.
php-eval (eval)
Evaluate arbitrary php code after bootstrapping Drupal.
updatedb (updb)
Apply any database updates required (as with running update.php).
variable-get (vget)
Get a list of some or all site variables and values
variable-set (vset)
Set a variable.
watchdog show
Shows recent watchdog log messages. Optionally filter for a specific type.
pm-enable (en)
Enable one or more extensions (modules or themes).
pm-disable (dis)
Disable one or more extensions (modules or themes).
pm-download (dl)
Download projects from drupal.org or other sources.
pm-uninstall
Uninstall one or more modules.
pm-updatecode (upc)
Update Drupal core and contrib projects to latest recommended releases.
pm-update (up)
Update Drupal core and contrib projects and apply any pending database updates (Same as pm-updatecode + updatedb).
sql-cli (sqlc)
Open a SQL command-line interface using Drupal's credentials.
sql-connect
A string for connecting to the DB.
sql-dump
Exports the Drupal DB as SQL using mysqldump.
This manual only lists a few of the most frequently used builtin commands shipped with the Drush core, since other Drupal modules and
third-party "command files" may extend this list significantly. The canonical source of information for the available commands and their
usage is the online help system.
More information on each command is also available through drush help <command>. Most commands have shortcuts indicated in parenthesis.
FILES
/etc/drush/drushrc.php
/usr/share/doc/drush/examples/example.drushrc.php
SEE ALSO cvs(1), svn(1), wget(1).
AUTHOR
Drush was originally developed by Arto for Drupal 4.7 (this alpha code can still be found in the DRUPAL-4-7 branch). In May 2007, it was
partly rewritten and redesigned for Drupal 5 by frando. Since 2008, the module has been maintained by Moshe Weitzman, Owen Barton and
Adrian Rossouw.
This manual page was written by Antoine Beaupre <anarcat@debian.org> in June 2009 for the Debian project (but may be used by others).
January 11, 2011 DRUSH(1)