06-03-2009
Could it be you are selecting the wrong database? Maybe internal to MySQL it is simply 'jzwp' and not 'jzacsh_jzwp' ? So the login works and you have access to your own database. But you can't switch to a non-existent database, so you get the error. But because you successfully logged in, you get the database dump as normal.
9 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
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)
Discussion started by: kolton
5 Replies
2. UNIX for Dummies Questions & Answers
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)
Discussion started by: perleo
4 Replies
3. Shell Programming and Scripting
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)
Discussion started by: perleo
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: blesets
2 Replies
5. Shell Programming and Scripting
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)
Discussion started by: learnbash
2 Replies
6. Web Development
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)
Discussion started by: thibautp
1 Replies
7. Shell Programming and Scripting
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)
Discussion started by: lowmaster
0 Replies
8. Shell Programming and Scripting
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)
Discussion started by: ojobson
3 Replies
9. Shell Programming and Scripting
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 SUNOS
asadmin-restart
asadmin-hadbm-restart(1ASS) User Commands asadmin-hadbm-restart(1ASS)
NAME
asadmin-hadbm-restart, hadbm-restart, restart - restarts the database
SYNOPSIS
restart [--no-rolling] [database_name]
Use the restart command to restart the database. Once the database is restarted, the database should return to the previous state. If the
database name is specified, the database should exist. If a database is not identified, the default database is restarted. The default
database is hadb.
In interactive mode, the restart command prompts for a confirmation before restarting the database.
OPTIONS
-g --no-rolling restarts all nodes in HADB at once with possible loss of service.
OPERANDS
database_name name of the database. The default database is hadb.
Example 1: Using restart with a database identified
hadbm> restart --rolling mydatabase
This command will restart the named database.
Type "yes" or "y" to confirm this operation,
anything else to cancel:y
Database successfully restarted
EXIT STATUS
105 database is not running
106 database could not be restarted
107 database could not return to a previous state
asadmin-hadbm-status(1ASS), asadmin-hadbm-nodestatus(1ASS), asadmin-hadbm-list(1ASS), asadmin-hadbm-addnodes(1ASS), asadmin-hadbm-
clear(1ASS), asadmin-hadbm-refragment(1ASS), asadmin-hadbm-delete(1ASS), asadmin-hadbm-start(1ASS), asadmin-hadbm-stop(1ASS)
Sun ONE Application Server 7 Enterprise Edition Early Access 7 March 2003 asadmin-hadbm-restart(1ASS)