Previous Thread
Next Thread
Print Thread
Rate Thread
#3482 07/23/02 12:19 PM
Joined: Mar 2002
Posts: 138
Likes: 1
C
Cyrez Offline OP
UGN Member
OP Offline
UGN Member
C
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]
#3483 07/23/02 01:15 PM
Joined: Mar 2002
Posts: 197
P
Member
Offline
Member
P
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
Offline
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
Cyrez Offline OP
UGN Member
OP Offline
UGN Member
C
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
Offline
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
Offline
Member
P
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
Cyrez Offline OP
UGN Member
OP Offline
UGN Member
C
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
Offline
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
Cyrez Offline OP
UGN Member
OP Offline
UGN Member
C
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
Posts: 35
Joined: August 2003
Forum Statistics
Forums41
Topics33,840
Posts68,858
Average Daily Posts0
Members2,176
Most Online3,253
Jan 13th, 2020
Latest Postings
Where and how do you torrent?
by danni75 - 03/01/24 05:58 AM
Animation,
by JohanKaariainen - 08/15/19 01:18 AM
Blackbeard.....
by Gremelin - 10/03/18 07:02 PM
my old account still exists!
by Crime - 08/10/18 02:47 PM
Okay WTF?
by HenryMiring - 09/27/17 01:45 AM
The History Thread...
by Gremelin - 08/11/17 12:11 PM
My friend NEEDS your HELP!
by Lena01 - 07/21/17 12:06 AM
I'm having fun with this guy.
by gabithompson730 - 07/20/17 01:50 AM
I want to upgrade my phone
by gabithompson730 - 07/20/17 01:49 AM
Doom 3
by Cyrez - 09/11/14 08:58 PM
Amazon Gift Card Generator/KeyGen?te
by Gecko666 - 08/22/14 09:21 AM
AIM scene 99-03
by lavos - 09/02/13 08:06 AM
Planetside 2
by Crime - 03/04/13 07:10 AM
Beta Testers Wanted
by Crime - 03/04/13 06:55 AM
Hello Everyone
by Gremelin - 02/12/12 06:01 PM
Tracfone ESN Generator
by Zanvin Green - 01/18/12 01:31 PM
Python 3 issue
by Testing - 12/17/11 09:28 PM
tracfone airtime
by Drache86 - 07/30/11 03:37 AM
Backdoors and the Infinite
by ZeroCoolStar - 07/10/11 03:52 AM
HackThisZIne #12 Releaseed!
by Pipat2 - 04/28/11 09:20 PM
gang wars? l33t-wars?
by Gremelin - 04/28/11 05:56 AM
Consolidate Forums
by diggin2deep - 04/21/11 10:02 AM
LAN Hacking Noob
by Gremelin - 03/12/11 12:42 AM
Top Posters
UGN Security 41,392
Gremelin 7,203
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Top Likes Received
Ghost 2
Crime 1
Ice 1
Dartur 1
Cyrez 1
Powered by UBB.threads™ PHP Forum Software 7.7.5