Import Just One Table From A Sql Backup
Nov 13, 2007I 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 RepliesI 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 RepliesHow I can import my backups from remote backup space to my VPS.
View 6 Replies View Relatedhow 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
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 RelatedHow do you import a database using webmin?
View 8 Replies View Relatedmy 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 RelatedI 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.
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?
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
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?
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?
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
Does anyone know if is it possible? If yes, how could I do this?
View 1 Replies View RelatedI 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
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.
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 RelatedChrome/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?
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.
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.
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.
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
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?
How to import mysql dump file to database by SSH?
How to import mysql database host to other host database by SSH?
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.
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 RelatedI'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
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.
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..
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 RelatedI 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..