Previous Thread
Next Thread
Print Thread
Rate Thread
#3482 07/23/02 12:19 PM
Joined: Mar 2002
Posts: 138
Likes: 1
C
UGN Member
UGN Member
C Offline
Joined: Mar 2002
Posts: 138
Likes: 1
I wannna backup my my sql db's via the command line since i cant do it via my cpanel. so how do i do this..


_-={N3TMASK.COM}=-_ [MAXIMUM INTERNET SECURITY]
Sponsored Links
▼ Sponsored Links ▼ ▲ Sponsored Links ▲
#3483 07/23/02 01:15 PM
Joined: Mar 2002
Posts: 197
P
Member
Member
P Offline
Joined: Mar 2002
Posts: 197
for backing up:
mysqldump $databasename -u $user -p$password > /home/$user/file.dump, that should do it

to put it back on it's place:
mysql $databasename -u $user -p$password < /home/$user/file.dump

that should do it


Never argue with fools... They will only drag you down to their level, and beat you with experience...
#3484 07/23/02 08:51 PM
Joined: Mar 2002
Posts: 562
UGN Supporter
UGN Supporter
Joined: Mar 2002
Posts: 562
Look into getting PHPMyAdmin

You can do a lot of that stuff in there also, A realy good progy. Most places that have Cpanel have it installed.

#3485 07/26/02 09:07 PM
Joined: Mar 2002
Posts: 138
Likes: 1
C
UGN Member
UGN Member
C Offline
Joined: Mar 2002
Posts: 138
Likes: 1
I typed the following...
bash-2.05$ mysqldump -u cyrez_cyrez -p cyrez_nuke -h n3tmask.com>backup.txt

Igot
Enter password:
mysqldump: Got error: 1130: Host '64.21.182.95' is not allowed to connect to this MySQL server when trying to connect

but it still makes a backup.txt file is it valid. .or is it junk..


_-={N3TMASK.COM}=-_ [MAXIMUM INTERNET SECURITY]
#3486 07/29/02 01:07 PM
Joined: Mar 2002
Posts: 562
UGN Supporter
UGN Supporter
Joined: Mar 2002
Posts: 562
Should look something like this

Code
 
# phpMyAdmin MySQL-Dump
# version 2.2.2
# http://phpwizard.net/phpMyAdmin/
# http://phpmyadmin.sourceforge.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 29, 2002 at 04:00 PM
# Server version: 3.23.45
# PHP Version: 4.1.2
# Database : `your_database_name`
# --------------------------------------------------------

#
# Table structure for table `Table_name`
#
CREATE TABLE Table_name(
  feild_name varchar(255) default NULL,
  feild2_name int(11) NOT NULL auto_increment,
  PRIMARY KEY  (id)
) TYPE=MyISAM;

#
# Dumping data for table `Table_name`
#
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered'', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
INSERT INTO Table_name VALUES ('feild_you_entered', 'feild_you_entered');
# --------------------------------------------------------
 
The process continues for each table within that database. That is of course if you backed up the whole data base. I am telling you PHPmyAdmin makes it a LOT easier.

#3487 07/29/02 02:26 PM
Joined: Mar 2002
Posts: 197
P
Member
Member
P Offline
Joined: Mar 2002
Posts: 197
Quote:
Originally posted by Cyrez:
I typed the following...
bash-2.05$ mysqldump -u cyrez_cyrez -p cyrez_nuke -h n3tmask.com>backup.txt
I hope you're joking :rolleyes:


Never argue with fools... They will only drag you down to their level, and beat you with experience...
#3488 07/29/02 06:58 PM
Joined: Mar 2002
Posts: 138
Likes: 1
C
UGN Member
UGN Member
C Offline
Joined: Mar 2002
Posts: 138
Likes: 1
of coarse


_-={N3TMASK.COM}=-_ [MAXIMUM INTERNET SECURITY]
#3489 07/29/02 07:43 PM
Joined: Mar 2002
Posts: 562
UGN Supporter
UGN Supporter
Joined: Mar 2002
Posts: 562
YOur cpanel has PHPMyadmin... Trust me.

Get into there and look around right after you open up your data base. It will be in the main frame. just below the list of tables in the data base.

The will be a check box that say

Save as

#3490 07/29/02 10:05 PM
Joined: Mar 2002
Posts: 138
Likes: 1
C
UGN Member
UGN Member
C Offline
Joined: Mar 2002
Posts: 138
Likes: 1
i know it has phpmyadmin i know about that stuff. but the cpanel dosnt work cuz my webhost is stupid and im leavin them and they dont know what there doin..


_-={N3TMASK.COM}=-_ [MAXIMUM INTERNET SECURITY]

Link Copied to Clipboard
Member Spotlight
Gremelin
Gremelin
Portland, OR; USA
Posts: 7,204
Joined: February 2002
Forum Statistics
Forums41
Topics33,839
Posts68,797
Members2,177
Most Online73,244
Nov 9th, 2025
Latest Postings
Top Posters
UGN Security 41,392
Gremelin 7,204
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Likes Received
Ghost 2
unreal 1
Crime 1
Ice 1
Dartur 1
Powered by UBB.threads™ PHP Forum Software 8.0.0