esport Posted September 20, 2006 Share Posted September 20, 2006 Hi guys,Im trying to back my database up by using mysqldump and saving the results in a .sql file. However the file is returned with a few lines of text and not the sql of the tables.Here is a snipet of the code i am using:[code]$LOCAL_DUMP_PATH = "db_back/"; $FILENAME_PREFFIX = "sqldump"; $filename = $FILENAME_PREFFIX.date("YmdHis").".sql"; $dump_cmd = "mysqldump -h'$DB_HOST' -u'$DB_USERNAME' -p'$DB_PASSWORD'";$dump_cmd .= " --all-databases";$dump_cmd .= " > $LOCAL_DUMP_PATH$filename"; exec($dump_cmd); [/code] ThanksDaniel Quote Link to comment Share on other sites More sharing options...
fenway Posted September 21, 2006 Share Posted September 21, 2006 You'd have to check the default options for mysqldump on the refman page... I'm not sure why you'd only get partial output. Quote Link to comment Share on other sites More sharing options...
esport Posted September 21, 2006 Author Share Posted September 21, 2006 Not sure what the refman page is? Is there anyother way to dump an entire mysql database into a text file?D Quote Link to comment Share on other sites More sharing options...
fenway Posted September 21, 2006 Share Posted September 21, 2006 Well, you could use SELECT INTO OUTFILE, but mysqldump is better... Quote Link to comment Share on other sites More sharing options...
esport Posted September 21, 2006 Author Share Posted September 21, 2006 This is the output i get:[tt]-- MySQL dump 10.10---- Host: localhost Database: -- -------------------------------------------------------- Server version 4.1.21/*!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 */;---- Current Database: `IT2002_actiond`--CREATE DATABASE /*!32312 IF NOT EXISTS*/ `IT2002_actiond` /*!40100 DEFAULT CHARACTER SET latin1 */;USE `IT2002_actiond`;[/tt] Quote Link to comment Share on other sites More sharing options...
fenway Posted September 21, 2006 Share Posted September 21, 2006 Take a look here: [url=http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html]http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html[/url] -- I'm not sure why you're not getting any data output. Quote Link to comment Share on other sites More sharing options...
esport Posted September 22, 2006 Author Share Posted September 22, 2006 I had a look at this page before, it didn't realy help as in why it is not producing an output. Its really doing my head in as im sure im doing everything right,.D Quote Link to comment Share on other sites More sharing options...
effigy Posted September 22, 2006 Share Posted September 22, 2006 Could it be permission problems?Are you using InnoDB tables? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.