UGN Security Forums
My ProfileMember DirectoryLogin
Search our ForumsView our FAQView our Site Rules
View our CalendarView our Active TopicsGo to our Main Page

UGN Security Store
 

Network Sites UGN Security, The GoNix Initiative, Elite Web Gamers, Back of the Web, EveryDay Helper, VNC Web Design & Development
September
Su M Tu W Th F Sa
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
Sponsored Links
Latest Postings
The History Thread...
by Gremelin
09/18/14 12:42 PM
Doom 3
by Cyrez
09/11/14 11:58 PM
Latest Reviews
Topic Options
Rate This Topic
#3482 - 07/23/02 03:19 PM My Sql Help
Cyrez Offline
UGN Member

Registered: 03/02/02
Posts: 136
Loc: 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 04:15 PM Re: My Sql Help
Predator Offline
Member

Registered: 03/01/02
Posts: 197
Loc: 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/23/02 11:51 PM Re: My Sql Help
Le4rner Offline
UGN Supporter

Registered: 03/05/02
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.
_________________________
http://promodtecnologies.com/rrfn

Top
#3485 - 07/27/02 12:07 AM Re: My Sql Help
Cyrez Offline
UGN Member

Registered: 03/02/02
Posts: 136
Loc: 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 04:07 PM Re: My Sql Help
Le4rner Offline
UGN Supporter

Registered: 03/05/02
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.
_________________________
http://promodtecnologies.com/rrfn

Top
#3487 - 07/29/02 05:26 PM Re: My Sql Help
Predator Offline
Member

Registered: 03/01/02
Posts: 197
Loc: 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/29/02 09:58 PM Re: My Sql Help
Cyrez Offline
UGN Member

Registered: 03/02/02
Posts: 136
Loc: O.C
of coarse
_________________________
_-={N3TMASK.COM}=-_ [MAXIMUM INTERNET SECURITY]

Top
#3489 - 07/29/02 10:43 PM Re: My Sql Help
Le4rner Offline
UGN Supporter

Registered: 03/05/02
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
_________________________
http://promodtecnologies.com/rrfn

Top
#3490 - 07/30/02 01:05 AM Re: My Sql Help
Cyrez Offline
UGN Member

Registered: 03/02/02
Posts: 136
Loc: 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

Moderator:  Infinite 
Featured Member
Registered: 03/02/02
Posts: 136
Forum Stats
2148 Members
46 Forums
34703 Topics
69873 Posts

Max Online: 1567 @ 04/25/10 05:20 AM
Top Posters
UGN Security 27865
Gremelin 7193
§intå× 3255
SilentRage 1273
Ice 1146
pergesu 1136
Infinite 1041
jonconley 955
Girlie 908
unreal 860
Newest Members
Tim050, Gecko666, defghi795767, Devo60, ali
2148 Registered Users
Who's Online
0 registered (), 296 Guests and 251 Spiders online.
Key: Admin, Global Mod, Mod
Latest News


Donate
  Get Firefox!
Get FireFox!