Jump to content

Archived

This topic is now archived and is closed to further replies.

esport

Mysql dump - database backup

Recommended Posts

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]

Thanks
Daniel

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
Not sure what the refman page is?

Is there anyother way to dump an entire mysql database into a text file?

D

Share this post


Link to post
Share on other sites
Well, you could use SELECT INTO OUTFILE, but mysqldump is better...

Share this post


Link to post
Share on other sites
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]

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
Could it be permission problems?
Are you using InnoDB tables?

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.