Confused maybe about MySQL Dump & PHP - Page 2

otheus · #1 (**permalink**) 06-03-2009

Quote:

i'm guessing that means I can't run things properly? (I'm not sure, I obviously had a shell to output a file with and everything... I just wasn't successful in outputting a GOOD file)

Redirect stderr from mysqldump as well. Use &> instead of just >

jzacsh · #2 (**permalink**) 06-03-2009

Quote:

Originally Posted by otheus

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)

Code:

Enter password: mysqldump: Got error: 1045: Access denied for user 'jzacsh_jzacsh'@'localhost' (using password: NO) when trying to connect

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

otheus · #3 (**permalink**) 06-03-2009

Isn''t that curious... with mysqldump, you have to specify --password, not -p.

mysqldump -u jzacsh_jzacsh --password=wordpres --single-transaction jzacsh_jzwp

jzacsh · #4 (**permalink**) 06-03-2009

Quote:

Originally Posted by otheus

Isn''t that curious... with mysqldump, you have to specify --password, not -p.

mysqldump -u jzacsh_jzacsh --password=wordpres --single-transaction jzacsh_jzwp

aah! thank you. okay, this is now what I get:

Code:

mysqldump: Got error: 1044: Access denied for user 'jzacsh_jzacsh'@'localhost' to database 'jzwp' when selecting the database
-- MySQL dump 10.11
--
-- Host: localhost    Database: jzwp
-- ------------------------------------------------------
-- Server version	5.0.81-community

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

any suggestions? how is it possible I'm still getting an access error at the beginning of the output, if I clearly have some kind of interaction going on below??

otheus · #5 (**permalink**) 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.

jzacsh · #6 (**permalink**) 06-03-2009

Quote:

Originally Posted by otheus

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.

wow that's amazing! (I had been trying that previously, when I had the --password syntax incorrect). Thank you so much for sticking around! I'll be finishing a book soon on PHP & MySQL and a 2-part unix admin course... you can be sure I'll be around to support these forums!

ps.
so that others can benefit, here's what the final proper output looks like for me:

Code:

mysqldump -u uname --password=psswd --single-transaction prefix_dbname | dd bs=1M | gzip -c > $sql_Path 2>&1

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
MySQL Developer, meet “Quan” (aka the MySQL Query Analyzer)	iBot	MySQL DevZone RSS	0	05-15-2009 01:30 PM
MySQL University - Training on MySQL Development & Internals	iBot	Solaris BigAdmin RSS	0	11-12-2008 09:10 AM
how to break mysql dump sql file	learnbash	Shell Programming and Scripting	2	05-14-2008 05:39 AM
restore mysql dump file in many remote servers?	blesets	Shell Programming and Scripting	2	09-13-2006 01:17 AM
help, what is the difference between core dump and panic dump?	aileen	UNIX for Dummies Questions & Answers	1	06-11-2001 08:08 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode	Rate This Thread: