Your browser does not seem to support CSS. If images appear below, please disregard them.
toggle
July
S M T W T F S
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31
Sponsored Links
Latest Postings
· Blackbeard.....
by Gremelin on 07/04/16 08:31 PM
Topic Options
Rate This Topic
#3482 - 07/23/02 07:19 PM My Sql Help
Joined: Mar 2002
Posts: 137
Cyrez Offline
UGN Member
Cyrez Offline
UGN Member

Joined: Mar 2002
Posts: 137
O.C
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]
Top
Sponsored Links
#3483 - 07/23/02 08:15 PM Re: My Sql Help
Joined: Mar 2002
Posts: 197
Predator Offline
Member
Predator Offline
Member

Joined: Mar 2002
Posts: 197
Belgium
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...
Top
#3484 - 07/24/02 03:51 AM Re: My Sql Help
Joined: Mar 2002
Posts: 562
Le4rner Offline
UGN Supporter
Le4rner 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.

Top
#3485 - 07/27/02 04:07 AM Re: My Sql Help
Joined: Mar 2002
Posts: 137
Cyrez Offline
UGN Member
Cyrez Offline
UGN Member

Joined: Mar 2002
Posts: 137
O.C
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]
Top
#3486 - 07/29/02 08:07 PM Re: My Sql Help
Joined: Mar 2002
Posts: 562
Le4rner Offline
UGN Supporter
Le4rner 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.

Top
#3487 - 07/29/02 09:26 PM Re: My Sql Help
Joined: Mar 2002
Posts: 197
Predator Offline
Member
Predator Offline
Member

Joined: Mar 2002
Posts: 197
Belgium
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...
Top
#3488 - 07/30/02 01:58 AM Re: My Sql Help
Joined: Mar 2002
Posts: 137
Cyrez Offline
UGN Member
Cyrez Offline
UGN Member

Joined: Mar 2002
Posts: 137
O.C
of coarse


_-={N3TMASK.COM}=-_ [MAXIMUM INTERNET SECURITY]
Top
#3489 - 07/30/02 02:43 AM Re: My Sql Help
Joined: Mar 2002
Posts: 562
Le4rner Offline
UGN Supporter
Le4rner 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

Top
#3490 - 07/30/02 05:05 AM Re: My Sql Help
Joined: Mar 2002
Posts: 137
Cyrez Offline
UGN Member
Cyrez Offline
UGN Member

Joined: Mar 2002
Posts: 137
O.C
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]
Top

Member Spotlight
Gremelin

Gremelin
Portland, OR; USA
Posts: 7,195
Joined: February 2002
Show All Member Profiles 
Forum Statistics
Forums46
Topics46,229
Posts81,399
Members2,157
Most Online1,567
Apr 25th, 2010
Top Posters(All Time)
UGN Security 39,393
Gremelin 7,195
§intå× 3,255
SilentRage 1,273
Ice 1,146
pergesu 1,136
Infinite 1,041
jonconley 955
Girlie 908
unreal 860
Newest Members
Herbert_Sherbert, codemauve, Lillysdragon1984, Brewwit, boa
2157 Registered Users
Who's Online Now
0 registered members (), 4 guests and 1 spider.
Latest News