Mysqldump :: JUST The Data, NO Table Information

Apr 14, 2008

From 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


ADVERTISEMENT

Mysqldump In Ssh

Jan 24, 2008

If 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

View 4 Replies View Related

Mysqldump -a Option?

Aug 4, 2008

Can 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 View Related

MySQLDUMP Cron Job

Apr 24, 2007

setting 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.

View 3 Replies View Related

Mysqldump With Slave Hard Drive

Mar 26, 2008

This 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.

View 1 Replies View Related

Disable Mysqldump Prompting For Password

Apr 17, 2008

how 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!

View 14 Replies View Related

Giving Chrooted User Access To Mysqldump

Aug 3, 2009

I 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 Related

Plesk 12.x / Linux :: Backup Fails Mysqldump - Got Error - 1016

Jun 3, 2015

I 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

View 3 Replies View Related

How To Run OPTIMIZE TABLE

Mar 25, 2009

Today i need to run "OPTIMIZE TABLE" from MySQLTuner recommendation.

Now i don't know how to run it ? I try to put in SQL Query via phpmyadmin and:

SQL query:

OPTIMIZE TABLE

MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

View 5 Replies View Related

Full BGP Table

Apr 19, 2007

Can i expect a 7204VXR NPE-300 router with 256Meg to hold a full BGP table?

Would it be possible to hold to full BGP tables (multihoming) with a NPE-400 with 512Meg?

View 9 Replies View Related

Attachment Table

Oct 21, 2007

I have a site running on vps and the attachment table got crashed , I am unable to repair it :

thesymbi_vb.attachment
error : Not enough memory for blob at 605100 (need 6315809)
warning : Number of rows changed from 4 to 3081
status : OK

This is result of repairing from WHM, how to repair it?

View 5 Replies View Related

My.cnf Have Delete The Table

May 9, 2007

i have update my.cnf with the following configuration and now i have a lor of customer that have lost him table, seem that this configuration have delete in random .Myi files, i would put this my.cnf also on others server but i would undestand which setting in this .cnf make problem for the table.

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
#skip-networking
safe-show-database
query_cache_limit=1M
query_cache_size=96M ## 32MB for every 1GB of RAM
query_cache_type=1
max_user_connections=200
max_connections=500
interactive_timeout=10
wait_timeout=20
connect_timeout=20
thread_cache_size=128
key_buffer=384M ## 128MB for every 1GB of RAM
join_buffer=1M
max_connect_errors=20
max_allowed_packet=16M
table_cache=1024
record_buffer=1M
sort_buffer_size=3M ## 1MB for every 1GB of RAM
read_buffer_size=3M ## 1MB for every 1GB of RAM
read_rnd_buffer_size=3M ## 1MB for every 1GB of RAM
thread_concurrency=2 ## Number of CPUs x 2
myisam_sort_buffer_size=64M
server-id=1
log_slow_queries=/var/log/mysql-slow-queries.log
long_query_time=2
collation-server=latin1_general_ci

[mysql.server]
user=mysql
#basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/lib/mysql/mysql.pid
open_files_limit=8192

[mysqldump]
quick
max_allowed_packet=16M

[mysql]
no-auto-rehash
#safe-updates

[isamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[myisamchk]
key_buffer=64M
sort_buffer=64M
read_buffer=16M
write_buffer=16M

[mysqlhotcopy]
interactive-timeout

View 3 Replies View Related

CPU Information

Oct 30, 2008

Is there a way in shell, to find out information on the CPU(s) in the server?
I'm using Centos, on a cPanel server. However, I'm looking for more info than what WHM's "Server Information" provides.

Trying to find out what generation Xeon is in the server, so I can read about it's specs.

View 6 Replies View Related

VPS Information

Jul 18, 2007

I am interesting for VPS but iwant windows 2003 with mssql2005 installed...
is there any company supporting this?

View 5 Replies View Related

Information About VPS

May 6, 2007

How do you get like for example ROOT of cPanel in a VPS? How would you be able to use it besides like giving permission to use WHM and stuff on accounts. As doesn't remote reboot and such have to happen on the whole server?

View 5 Replies View Related

Can't Initialize Iptables Table

Mar 12, 2008

On my new unmanaged VPS i keep getting mass emails sent to me saying -

iptables v1.2.11: can't initialize iptables table `filter': iptables who? (do you need to insmod?)
Perhaps iptables or your kernel needs to be upgraded.

Im a bit of a n00b when it comes to unmanaged servers, just wondering if anyone knows whats wrong and how to fix.

View 6 Replies View Related

Mysql: Copying To Tmp Table

May 18, 2009

mysql: Copying to tmp table, what causes that?

My server is majorly overloading and mysql is atop the cpu, and when I do a processlist there are about 20 copying to tmp table processes.

View 3 Replies View Related

Table Marked As Crashed.

Apr 5, 2009

I have a table that is showing

MySQL Error: 145 (Table './dollarpt_ptc/flinks' is marked as crashed and should be repaired)

I've repaired it via
mysqlcheck --repair --all-databases

that didn't work. I've tried
find /var/lib/mysql/* -name *MYI |xargs myisamchk -o -r
as well with no luck.

I then dropped the table and I still get the message. I know it's using the correct database, so any help would be appreciated.

It's like there is a table where this data is kept, but I've looked and can't find anything.

View 2 Replies View Related

MySQL Table Crashed

Sep 28, 2007

Table '231_message' is marked as crashed and should be repaired

I haven't ever had this happen, is all my data truely lost or can i 'repair' it

i was moving sites to a different server (VPS -> dedicated) and on the vps i have a max of 20gb storage, well as i was using the cpanel transfer it filled this up because it didnt have a warning about this (i dont accept blame )

either way it seemed at this time someone on my site tried to make an adjustment to the table and it crashed it since there wasnt room? i really need to get this fixed asap so I can properly move this site with a working database

View 5 Replies View Related

Import Just One Table From A Sql Backup

Nov 13, 2007

I have a sql backup and I just want to restore the attachment table from it! , can anyone explain me how to do so?

View 4 Replies View Related

Configuring DNS Information

Mar 24, 2009

I am moving my servers this week and my new host doesn't do domain hosting. This is my first time doing it, I need help in pointing my domain to the new server. I just need the basic settings for A, CNAME and MX records.

View 13 Replies View Related

Backing Up Information

Feb 18, 2009

I understand that servers can do automatic backups of information, yet I also see forum modifications that enable simple ways of doing a backup. Are there different types of backups? Why is it necessary to manually backup a forum database when its done automatically by the server? In terms of assuring the data, what is required and whats a typical procedure, what does it entail, is it manual and if so usually how often, or is it usually automatic?

View 2 Replies View Related

Information On Ourinternet.us

May 25, 2008

it looks good and the prices are reasonable, I wonder if anybody has had any experience with them.

View 2 Replies View Related

My Information Server

Oct 28, 2007

how may i can understand full information of my server for example my hdd is sata or ide
whats my memory and ... my server is centos

View 11 Replies View Related

Optimizing Large MySQL Table

Nov 2, 2009

I optimized a mysql table of 2 million records and about 500MB.. it took about 15 minutes.. However, on the same DB now i have another huge table of 88 million records, it size is 2.2 GB and it has about 30 MB to optimize... my questions..

1.- How can I speed up the optimization process so it can take the less possible time? any tweaks to my.cnf?

2.- Should I repair it using phpmyadmin or just from the shell?

3.- Should I stop http traffic during this optimization?

This is a dedicated db mysql server that handles a large VB forum with 5-8 users online average:

Code:
Intel Xeon 3.2 x4 procs, 32 bits, 4 GB ram
/etc/my.cnf

Code:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-locking
skip-innodb
skip-bdb
query_cache_limit=1M
query_cache_size=48M
query_cache_type=1
max_connections=1200
interactive_timeout=100
wait_timeout=300
connect_timeout=10
thread_cache_size=128
key_buffer=48M
join_buffer=8M
max_allowed_packet=16M
table_cache=2036
sort_buffer_size=1M
read_buffer_size=1M
read_rnd_buffer_size=2M
max_connect_errors=10
# Try number of CPU's*2 for thread_concurrency
thread_concurrency=4
myisam_sort_buffer_size=64M

# Add
max_heap_table_size = 48M
tmp_table_size = 48M
low_priority_updates=1
concurrent_insert=2

[mysqldump]
quick
max_allowed_packet=16M

[mysql.server]
user=mysql
#basedir=/var/lib

[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
log-slow-queries=/var/log/slow-queries.log

On the other side, i have the same hardware for the webserver..

View 2 Replies View Related

Deleted Columns_priv Table MySQL

Jun 24, 2009

I accidentally deleted the columns_priv table in mysql database. How can I bring it back can anyone show me the structure of that table so I can build it back.

View 4 Replies View Related

Mysql: Incorrect Key File For Table

Apr 20, 2009

I have a server with many db on mysql 5

Any db contains 5 table with data

This data is processed by routine

Many time routine die with the error:
"Incorrect key file for table '/var/tmp/#sql_3018_0.MYI'; try to repair it"

The table sql_3018_0.MYI not exist, think that this is refered to a temporary table but is deleted by process..

View 1 Replies View Related

MYSQL Incorrect Key File For Table

Jul 3, 2008

what I can do about the following database error in mysql?

Incorrect key file for table '/tmp/#sql_(number of table.MYI); try to repair it

I've repaired, optimized and checked the database in phpmyadmin. Initially 2 tables were showing overhead, but the error message is for a temp table and I'm not sure how to try to repair a temp table.

View 5 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved