Mysqldump -a Option?
Aug 4, 2008Can anyone tell me what the "-a" option is for in mysqldump? I've seen it in use but can't seem to find it in the documentation.
View 4 Replies
ADVERTISEMENT
Mysqldump In Ssh
Jan 24, 2008If a friend of your's asked you what they should type in SSH to make a backup of a MySQL database so they would have it to restore if anything were to happen to their server (drive failure, DB corruption, etc etc).. what would you tell them to type in?
The reason I ask this is because doing my own research on the net on how to backup a mysql database in SSH has shown me there are 10 million ways of doing it, with all kinds of modifiers and so forth. Not having a good grasp on what these modifiers do, I am not sure what to use?
For instance, here is what I have been using:
mysqldump --opt -udb_username -p db_name > /home/username/thebackupfile.sql
MySQLDUMP Cron Job
Apr 24, 2007setting up a new cron job.
I would like to have MySQLDUMP dump my specified database(s) into a specified folder using date and time stamps in the filename.
I've done some searching on this but haven't really came up with a way to do all of this at once, or if I may need to setup a cron job to rename the file after the dump has completed. I may be going about this all wrong to begin with, I'm just looking for a very simple and reliable way to backup my databases.
I'm testing this on a Shared Web Host account at this time which does have SSH shell access, but I wasn't sure if this makes a difference.
Mysqldump :: JUST The Data, NO Table Information
Apr 14, 2008From Linux Shell, I need to back up a mysql database, JUST the data, NO Table information. Which options in mysqldump do I use?
View 14 Replies View RelatedMysqldump With Slave Hard Drive
Mar 26, 2008This week I reached the pinnacle of all time greatest screw ups I've ever done with a web server in five years. During a routine upgrade, my server crashed and basically burned to the point that the technicians at Burst/Nocster felt it would be in my best interest to clear the server out and do a fresh restore.
Fortunately, I had the majorty of files and designs I've done on a safe backup. Unfortunately, the mysql database I had was not so fresh and recent. In there lies my big problem on an issue I really have not seen much information about.
We all know of the mysqldump command that can be used to backup databases and save a .sql file on the server. Its quick, easy, and relatively painless. The problem I have run into is
mysqldump --opt -u nqforum_braduser -p nqforum_nodqdb > /home/nqcom/backup.sql
This would be the command I'd use on my normal mysql dump. However, all of my files and past server information has been installed as a slave hard drive temporarily until I can gather everything I need. Therefore, the command above won't work because it is looking for this mysql database & user that does not exist on the new server. I currently have the slave hard drive path stored at
/mnt/olddrive/
So for example, to get to the website that would have that particular database
/mnt/olddrive/home/nqforum/
So my question for those who know anything about slave hard drives and mysql, how can I get a simple current backup of this database saved to a location, then of course once it is saved as a .sql file somewhere, I can simply run a mysql restore command in SSH to bring it back.
Disable Mysqldump Prompting For Password
Apr 17, 2008how do I make mysqldump command to run and make sql dump directly without prompting me for password
on cpanel server i can do this directly
# mysqldump database_database > /backup/backup.sql
on direct admin server i only can do this
# mysqldump -u root -p database_database > /backup/backup.sql
Enter password:
I don't want this because I'm going to run this command on cronjob!
Giving Chrooted User Access To Mysqldump
Aug 3, 2009I have a chrooted ftp user that I use on my server. I would like to run a cron job using this user that backs up my mySQL databases. When I execute the job, it complains about date and mysqldump not existing. I was able to fix the date problem simply by copying it from the actual /bin to the chrooted /bin. However, I can't simply copy mysqldump because it depends on several libraries. Anybody know how I can give this chrooted user access to commands that aren't in his chroot?
View 6 Replies View RelatedPlesk 12.x / Linux :: Backup Fails Mysqldump - Got Error - 1016
Jun 3, 2015I am having trouble with backing up a wordpress multisite.. When backup is on i am getting this error:
Not all the data was backed up into /var/lib/psa/dumps/domains/<domain>/databases/<db_name> successfully. mysqldump: Got error: 1016: Can't open file: './<db_name>/<some_table>.frm' (errno: 24) when using LOCK TABLES
Plesk - Fantastico-like Option?
Dec 30, 2008I'm using Plesk on one of my webhosts (GoDaddy) and would like to know if anyone knows of a good Cpanel Fantastico-like option that allows you to update a string of sites with the latest updates. I'm more familiar with Cpanel.
Do you know of any?
Migrating From 1&1 Shared - Best Option
Aug 18, 2008I'm fed up with the overloaded 1&1 shared hosting, looking into VPS now as I'm finally getting serious about one of my sites.
I tried offloading scripts and images to amazon s3, which helps a bit, but any sort of php application processing is painful.
Admittedly, I haven't implemented caching at all yet and my query count is definitely bad but even so load times seems excessive as the site isn't getting any real use yet, just me testing (and I will make heavy use of caching for all entry points in the near near future).
My must-have:
-PHP5
-2 seperate MySQL databases
-htaccess/mod_rewrite
-fast initial response time on loads
-unlimited subdomains would be nice
Don't really care about the control panel as long as it does what I need. I'm fine with command line and managing myself... looking for a cheap option that will allow me to grow to a medium sized site before I consider a full dedicated option.
Also, don't need an outrageous amount of bandwidth as I'm using S3 for css,js,images, and video right now.
I will be running two domains on this site... one is the actual site and one is a single sign on gateway that won't put too much load on the cpu but needs to serve up pages in timely fashion.
Perhaps Skip The Cpanel Option
Jun 5, 2008if I should continue paying an extra $25 per month for Cpanel. Is it that hard to do without it? All I really do with Cpanel is configure Spamassassin, setup emails, and backups.
View 5 Replies View RelatedNtfs Or Fat32 Option
May 28, 2007I am planning to install windows2003 server. Do I need to choose fat32 option or NTFS as file system?
View 9 Replies View RelatedThe VPS Option With Gate Is Good
Jul 3, 2007do you think that Service and price in gate is good?
Monthly Rate $49.95/mo.
Annual Pre-pay Price $499.50/yr.
Setup Fee $19.95
Windows 2003
Disk Space 25GB
Data Transfer 1000GB
Guaranteed RAM 512MB
Websites/Domain Names 10
Mailboxes Unlimited
gate.com/vps/vpsw100.htm
50+ Domains, What Is The Best Option? Seo, Mirroring, Forwarding, Etc?
Jul 22, 2008I have a client that has one main ecommerce site and search engine ranking is very important.
They also have about 60 other domain names that are relevant to their main domain. example: pizzapie.com & cheesepizza.com.
The question I have is what would be the best way to utilize these domains without getting search engines mad (lose rank). Mirror? Forward? Or should I populate them with the same files? Or same files but change the text around as much as possible?
The last question is basically the same but they also have international domains with the same situation; pizzapie.jp, pizzapie.nz, etc. Would this be any different or does anyone have suggestions how to treat international domain names for ranking in US & the corresponding country?
Rkhunter :: Invalid Option Specified: -cronjob
Sep 18, 2009Server Detail : Ceontos / Cpanel
i have installed RKhunter several days ago , after installation i`m receving below email everynight
subjectDaily Rkhunter Scan Report
Invalid option specified: -cronjob
Corei7 Kernel Config Option
Jun 16, 2009I just got one of the new corei7 boxes, it looks pretty sweet. I am compilig a custom kernel now, doing linux-2.6.29.4 (latest grsecurity test patch kernel) and I do not see an option for the corei7, just Core2/Newer Xeon. I had been googling and seem some posts about kernels now supporting i7 but no info on the config. I do know the installed distro - centos5 64 bit, it ran fine on the first old kernel and latest kernel got in yum update.
Does anyone know of any patches or anything out there that will help harness the full capabilities of the i7? Or has anyone else compiled custom kernels for your i7 without issue and what processor type did you choose?
Disable Backup Option In Cpanel
Mar 15, 2008Is there any way to disable backup option for a reseller's accounts.
Please don't ask why I want this, there is lot of reasons for this.
/etc/named.conf:87: Unknown Option 'e'
Aug 11, 2008I have the following problem:
When i try to restart the nameserver service i get the following error:
# service named restart
Stopping named: [ OK ]
Starting named:
Error in named configuration:
/etc/named.conf:87: unknown option 'e'
/etc/named.conf:120: unexpected end of input
[FAILED]
my named.conf as follows:
include "/etc/rndc.key";
controls {
inet 127.0.0.1 allow { localhost; } keys { "rndc-key"; };
};
options {
/* make named use port 53 for the source of all queries, to allow
* firewalls to block all ports except 53:
*/
query-source port 53;
// Put files that named is allowed to write in the data/ directory:
directory "/var/named"; // the default
dump-file "data/cache_dump.db";
statistics-file "data/named_stats.txt";
/* memstatistics-file "data/named_mem_stats.txt"; */
};
logging {
/* If you want to enable debugging, eg. using the 'rndc trace' command,
* named will try to write the 'named.run' file in the $directory (/var/named).
* By default, SELinux policy does not allow named to modify the /var/named directory,
* so put the default debug log file in data/ :
*/
channel default_debug {
file "data/named.run";
severity dynamic;
};
};
// All BIND 9 zones are in a "view", which allow different zones to be served
// to different types of client addresses, and for options to be set for groups
// of zones.
//
// By default, if named.conf contains no "view" clauses, all zones are in the
// "default" view, which matches all clients.
//
// If named.conf contains any "view" clause, then all zones MUST be in a view;
// so it is recommended to start off using views to avoid having to restructure
// your configuration files in the future.
view "localhost_resolver" {
/* This view sets up named to be a localhost resolver ( caching only nameserver ).
* If all you want is a caching-only nameserver, then you need only define this view:
*/
match-clients { 127.0.0.0/24; };
match-destinations { localhost; };
recursion yes;
zone "." IN {
type hint;
file "/var/named/named.ca";
};
// include "/var/named/named.rfc1912.zones";
// you should not serve your rfc1912 names to non-localhost clients.
// These are your "authoritativ
zone "smpl.splinteredmedia.net" {
type master;
file "/var/named/smpl.splinteredmedia.net.db";
};
e" internal zones, and would probably
// also be included in the "localhost_resolver" view above :
};
view "external" {
/* This view will contain zones you want to serve only to "external" clients
* that have addresses that are not on your directly attached LAN interface subnets:
*/
recursion no;
// you'd probably want to deny recursion to external clients, so you don't
// end up providing free DNS service to all takers
// all views must contain the root hints zone:
zone "." IN {
type hint;
file "/var/named/named.ca";
};
// These are your "authoritative" external zones, and would probably
// contain entries for just your web and mail servers:
// BEGIN external zone entries
};
z
zone "smpl.splinteredmedia.net" {
type master;
file "/var/named/smpl.splinteredmedia.net.db";
};
I have cPanel installed on a CentOS 5.1 VPS
Backup Option In Master Reseller
Jun 18, 2008I have bought a Master Reseller recently.
I have some technical question in my mind regarding backup.
I will start step by step.
1) I login to the WHM.
2) I click to WHMreseller Master Resellers placed on the bottom of the left menu.
3) There I saw some options at the bottom , 'Migrate' , 'Backup' ,'Change Owner', 'IP Delegation'
4) I clicked on 'Backup'.
5) There I saw two check boxes:
Enable Weekly Automated FTP Backups
Enable Weekly Automated Local Backups (will only run if cpbackups are disabled by root)
My questions are very simple:
Q1) What these two check boxes mean ?
Q2) If i check 'Enable Weekly Automated FTP Backups' and save these settings then every week , back of my all cpanels including cpanels of reseller will be generated or wht?
Squirrelmail Password Change Option
Sep 12, 2007I have 2 question regarding squirrel mail web interface..
1- Can a user change his mailbox password?
2- Is mailing forwarding option include in it?
Cp: The --reply Option Is Deprecated! Some Alternative
Sep 14, 2007All time in cron on my servers I using:
cp --reply=yes /dev/null /dir/logfile
but on my new server this don`t working and error is:
cp: the --reply option is deprecated; use -i or -f instead
Plesk 11.x / Linux :: Cannot Add New SubDomain - No Such Option
Feb 21, 2015After I post my desired subdomain as mysubdomain.domain.com on /mysubdomain.domain.com/
I get "Error: phpinimng failed: Usage: phpinimng [options] [php_ini_file] phpinimng: error: no such option: --global-config" on main window.
Tried to search how to fix this error, i managed to find that there is also " missing or incorrect /usr/local/sb/include/init.php ". As for this error this doesn't work [URL] .... It's already correct permission 755.
The subdomain appears only in DNS records on my domain. But not in the main plesk panel window.
OS is Debian 7.6 and Plesk 11.5, mysql runs over sock
Maybe I could create manual configuration over ssh in /var/www/vhost/ dir ..?
Best Option Backing Up Cpanel Server To A Cloud
Sep 26, 2009I'd like to back one of our servers up using S3 but I'm not sure the best way to go. Server is using CPanel. Obviously I want to keep costs down.
I need the files to be secure, backups need to be nightly incremental, and I need to be able to restore to another CPanel server fast in case of hardware failure. CPanel supports FTP for backups. I currently back up to another server, but I want to move to the cloud.
Specific questions I have:
1. Any recommendations on a cloud backup service (S3, Rackspace, etc?), and why?
2. Any recommendations on tools? I want this to be simple to set up. As easy as setting up an FTP account.
3. Is there another option I should consider? That server has about 62GB of data on it to be backed up.
Best Unmetered Option For Starting My Viral Site
Oct 26, 2008What benefits/features do you think an unmetered dedicated server will need for a starting file hosting website that will market agressively/daily in forums/warez with the free benefit of 500mb of free hosting?
Simple/ but important details:
*I would like to manage the server myself with cPanel/WHM + Fantastico as I control about 60 of my websites in hostgator shared baby account(however, hostgator prices are way to high for dedicated)
*I have never had experience with dedicated server management and only have done dilligence as of today
* My budget is from $65.00 to $100.00
Will this next unmetered example be the perfect solution for fast uploads/downloads to start?
CELERON-3.06GHZ
1 GB RAM
80 GB IDE DRIVE
Unmetered
5 IPS
No Setup Fee
Does The Planet Offer Bi Yearly Payment Option
Oct 24, 2008I currently have one server at The Planet, paying 147/mo. Anyone know if they have any options to pay every 6 months at a slightly discounted price? I have no plans to move, so figured I'd look if I have that option to save money. Suppose it's something I could of asked them directly but thought I'd ask here in case anyone knows or has experience doing this, and whether or not it's worth it.
View 5 Replies View RelatedPlesk 12.x / Linux :: No Email Option For Domain
Jan 24, 2015I can't find email option in my plesk panel
I have installed mail servers in components, and i see mail settings under server tab but i just cant figure out how to enable mail for specific domain
If i go to webmail.pedjaapps.net i opens default home page, webmail subdomain points to my servers ip address in DNS, roundcube is also enabled in webmails....