Hi, I have backed up my db for the first time using shell access and putty.
I want to ask if someone can explain me how do I know if the backup is complete.
To make the Backup I have written:
mysqldump -u xxxxxxxxx -p xxxxxxxxxx > /path/to/backup.sql
The backup starts with
and ends with:
I don´t know why but I fell that this is wrong...
Thanks
I want to ask if someone can explain me how do I know if the backup is complete.
To make the Backup I have written:
mysqldump -u xxxxxxxxx -p xxxxxxxxxx > /path/to/backup.sql
The backup starts with
-- MySQL dump 9.10
--
-- Host: localhost Database: xxxxxxxxxxxxx
-- ------------------------------------------------------
-- Server version 4.0.1-standard
--
-- Table structure for table `xxxxx_access`
--
CREATE TABLE xxxxx_access (
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
accessmask smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid,forumid)
) TYPE=MyISAM;
--
-- Dumping data for table `xxxxxx_access`
--
--
-- Host: localhost Database: xxxxxxxxxxxxx
-- ------------------------------------------------------
-- Server version 4.0.1-standard
--
-- Table structure for table `xxxxx_access`
--
CREATE TABLE xxxxx_access (
userid int(10) unsigned NOT NULL default '0',
forumid smallint(5) unsigned NOT NULL default '0',
accessmask smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (userid,forumid)
) TYPE=MyISAM;
--
-- Dumping data for table `xxxxxx_access`
--
INSERT INTO xxxxxx_word VALUES (543,'probando');
INSERT INTO xxxxxx_word VALUES (544,'escribe');
INSERT INTO xxxxxx_word VALUES (545,'erestonto');
INSERT INTO xxxxxx_word VALUES (546,'firedevil');
INSERT INTO xxxxxx_word VALUES (547,'enfado');
INSERT INTO xxxxxx_word VALUES (548,'hgfhgfhfg');
INSERT INTO xxxxxx_word VALUES (544,'escribe');
INSERT INTO xxxxxx_word VALUES (545,'erestonto');
INSERT INTO xxxxxx_word VALUES (546,'firedevil');
INSERT INTO xxxxxx_word VALUES (547,'enfado');
INSERT INTO xxxxxx_word VALUES (548,'hgfhgfhfg');
Thanks
Comment