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


ADVERTISEMENT

Import File From A Remote Backup Space

Feb 13, 2008

How I can import my backups from remote backup space to my VPS.

View 6 Replies View Related

Import .sql.gz Database

Dec 13, 2008

how can import a .sql.gz database to mysql? i cant do it with following command:
mysql -p -u root uur445_db < wqee2_master_1.sql.gz

View 2 Replies View Related

Hebrew Database Import

Jul 2, 2009

My friend has a Hebrew Database and I wanted to know the best way to import it? (i have shell access).

View 4 Replies View Related

How To Import Database Through Webmin?

Jun 26, 2009

How do you import a database using webmin?

View 8 Replies View Related

Data Import To Mysql

Jun 17, 2008

my server is Linux with PLESK, one of our customers trying to import data to database, the data is in Unicode (Persian) and when he import that data show? in web site.

View 2 Replies View Related

Import 16 Meg File In Phpmyadmin

Aug 14, 2008

I have a very good free web hosting company. My one user needs to be able to upload a 16 meg sql file in php. I tried bigphp, but it game me an error that the sql file doesent have a semicolon followed by a linebreak at the end of each query in the file.

I know there is some sort of SSH command i can run to import this sql file to his account. I am using layered panel. So what is the easiest way here?

Also i have 20MB php.ini settings for uploads, post size, etc.

View 5 Replies View Related

How Can I Import .sql Form Mysql 4.1 To 4.0

Aug 30, 2007

i am not sure if this is the right sub-forum to post the question.

it is that i my a forum running with php and mysql,

the version of it is 4.1 now,

i wnat to move the forum to another server,

but the mysql version of the server is 4.0,

i try to backup the .sql form phpmyadmin and import form phpmyadmin,too.

but it failed,

some article tell me that i should change some setting in the .sql file,

but i try and failed,

can anyone teach me how can i process it?

View 5 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

Can I Import Mbox Into Imap Webmail?

Jan 31, 2007

Does anyone know if is it possible? If yes, how could I do this?

View 1 Replies View Related

How To Increase Import Max File In PhpMyAdmin

Dec 15, 2008

I have CentOs 5 With LxAdmin

My Current Import Max File in PhpMyAdmin is 8192 KiB

I have Changed Values in php.ini and my.cnf But Still No Luck At ALL, Its Not Working

View 4 Replies View Related

Import Email Passwords To CPanel

Nov 16, 2008

And now after creating a Joomla! site for a school that will be moving to my server from a local small isp that doesn't have a control panel (just a screen to allow users to set-up their email name and pwd) I'm stuck with trying to figure out how to set up their email accounts with their current password.

There are about 40 accounts that I can add manually, but when I change the nameservers, these teachers and staff are going to be at a loss as what to do; like I am at the moment.

View 10 Replies View Related

How To Import A Wordpress Blog From Anothe

Jan 1, 2007

I want to move domain names. However, I got a lot of good articles in a blog. How can I move the articles from one to another?

View 4 Replies View Related

Plesk 11.x / Linux :: Import SSL Into Chrome

Feb 3, 2015

Chrome/Chromium don't offer to "remember this password" if using https with a self signed, or no, certificate, which is pretty frustrating when your job requires regular logins to various Plesk installations!

The trick, apparently, is to import your self signed certificates into Chrome's chrome://settings/certificates list, so I'm trying to do this with Plesk's default panel certificate.

From Tools & Settings -> SSL Certificates, I've hit the 'Download the Panel's SSL Certificate' link to get the .pem file but when I import this into Chrome I'm asked to provide the password it was encrypted with. Where would I find this password? Or do I need to replace the default with my own self-signed?

View 8 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

Edit PhpMyAdmin MySQL Max Import Size (Max: 8,192 KiB)

May 31, 2009

I currently am running on a VPS and I'm trying to edit the max size a user can upload through phpMyAdmin. I have tried editing the php.ini file located at /etc/php.ini to find it wasn't the right file.

Where do I need to go via SSH to edit the proper file?

View 6 Replies View Related

How To Import Mysql Dump File To Database By SSH

May 19, 2009

How to import mysql dump file to database by SSH?

How to import mysql database host to other host database by SSH?

View 4 Replies View Related

Trying To Import Mysql Database Via CLI In Ubuntu Linux

Dec 13, 2007

I have ubuntu 6 server version running.

I am trying to import a database I have however I cannot get it working for the last 2 hours!

I have tried various commands like logging into mysql entering the "use" command to use a database and then variations of the "source" command but my db.sql file doesn't run.

Also tried the full command

mysql -uroot -pMYPASS MYDBNAME < /var/www/site/db.sql

Neither seem to do anything.

PHPMYADMIN shows no database tables at all.

Running mySQL 5.

View 4 Replies View Related

Plesk 11.x / Linux :: Import DNS Zone Using Axfr

Apr 2, 2014

We have too many DNS servers such as BIND, PowerDNS, NSD on different platform.I need transfer all zones to Plsek server.Is there a ready-made solution import dns zones using axfr?

View 3 Replies View Related

Plesk Automation :: Import Aps Package Disappears

Jul 30, 2014

I've a sandbox, when i upload my package, the package disappear.

With aps build package and aps lint package I have no error and no warning, and on the panel when i import the package, simply disappears.

There is a log, a sign, I can not find the error.

I use APS 1.2

View 1 Replies View Related

Plesk Automation :: APS Packages - Import - Certification?

Feb 4, 2014

since upgrading PPA, I noticed that in the External Applications section, all the APS packages have a column "imported" and "certification" - what these are/mean?

I hit "import" on the wordpress package - but what it is doing and why it would be to our advantage to import an APS package, rather than have them externally hosted so they're always the latest version.

View 1 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







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