Restoring 1.5GB SQL Dump (Postgres)
This seemed like the most appropriate place so I decided to post here.
SYSTEM:
Fedora Core 4, 3GHz, 2GB RAM
Postgres 8, Apache 2, PHP 4
The issue is that I have with me a 1.5GB SQL dump from Postgres 8 which I extracted using pg_dump.
Restoring it seems to be an issue on this PC. I've tried modifying memory directives in postgresql.conf as well as the kernels SHMAX value but no go.
I tried a bunch of other things such as gzipping the file so that it was only 100mb and doing:
Code:
gunzip -c dump.sql.gz | psql my_db
But I recieved many errors saying "invalid command N" and I also got a syntax error notice and the process terminated.
I tried to at least try and enter some data manually but vim is incredibly slow since this is a 1.5GB file.
Is there a way I could perhaps split up my db dump and then import them into the db one by one?
View Complete Thread with Replies
Sponsored Links:
Related Forum Messages:
Postgres: Restoring A Filesystem Backup
i had to do a file system back up because of the size of my database. i shutdown postmaster and tar'd the files. i recently reloaded my OS and now i'm attempting to restore the backups. i first shut down postmaster, restored the backups to the data folder and restarted postmaster. i then su'd from root to postgres user: Code: [postgres@austin1 pgsql]$ psql service_2_3 psql: FATAL: database "service_2_3" does not exist DETAIL: The database subdirectory "base/16385" is missing. the backups had a database named service_2_3 but upon restoring the backups, it doesn't seem to be available. my data directory is /var/pgsql/data. Code: [postgres@austin1 pgsql]$ ls -lahR /var/pgsql/ | grep 16385 but that yielded nothing. have i done something wrong while backing up? i don't think i have since i followed the postgres manual when backing up. but the administrators have not been very thorough with how they've set the system up for me. how i can resolve this issue if you have the time.
View Replies!
View Related
CPLinks Categories SQL Dump
I am trying to configure CPLinks, anyone know where can I find such category dumps or do I need to key in one by one? Tried to contact cplinks side for the dumps but no response. Do let me know if anyone had prepared such dumps.
View Replies!
View Related
Restoring SQL Database Backup To Invision Power Board
I moved my site to a new host and am running IPB 1.3 forums, I have a 62meg sql backup to restore. I have tried using BIGDUMP.php as max upload is over 52megs. No Joy! I also tried zipping the file, got it down to 9megs, It wont complete the upload in PhpMyAdmin? I have not had to restore a back up before, and am really struggling.
View Replies!
View Related
5GB Space Lost
We delete LOGS. We delete QUEUE mail. After we add up all the space of the counts. space of count1 + space of count2 + space of count3 + ... ALL COUNTS And TOTAL < to 2GB included MySQL space But space used (say Vistuozzo), is 8.47 Gb! How we can understand this? Ok, maybe 2 GB of CENTOS + cpanel + WHM+ MySQL + Files config = 2 GB Home + MySQL = 2GB 4 GB is very different to 8.5 GB! Ok think in 3 GB of SO+WHM+CONFIG add 2 GB of files this = 5 GB
View Replies!
View Related
Windows VPS With 1.5GB Ram
I'm trying to track down a quality windows VPS hosting supplier based in the US. I'm looking for a geat reputation, strong customer support and good flexibility... We are running a website that that has applications running fulltime in the background and will require for our beta phase - about 1.5GB of RAM... Can anyone point me in the direction of a good host? Ram is most critical, followed by uptime and service quality / parts quality... Things that aren't important are bandwidth, storage .etc
View Replies!
View Related
Postgres Install
I have a server running Cpanel and I have added postgres through /scripts/installpostgres, also I have set it over WHM and can access phppgadmin but I got this error when connecting throug a script Fatal error: Call to undefined function: pg_connect() in /home/rer1223/public_html/process/Connection.php on line 4 I checked and postgres is not listed in phpinfo output.
View Replies!
View Related
Cannot Add Postgres Database
PostgreSQL (Cannot add new user or database). It will return "User/DB added successfully" but no new user or database is added. root@server [~]# rpm -qa | grep postgre postgresql-devel-8.1.4-3PGDG postgresql-contrib-8.1.4-3PGDG postgresql-8.1.4-3PGDG postgresql-server-8.1.4-3PGDG postgresql-libs-8.1.4-3PGDG postgresql-python-8.1.4-3PGDG I've already compiled apache after postgres was upgraded months ago. I'm using cpanel 10x
View Replies!
View Related
Cron As Postgres User Not Working
I was hoping someone could shed some light on a cron related issue I'm having. I've been using linux for a while...but never really used crons. My cron is supposed to dump a postgres db in tar.gz format every minute (for testing purposes) but it doesn't. I opened my cron in vim via: Code: postgres@myhost:~$ crontab -e And here's the cron: Code: * * * * * /usr/bin/pg_dump -D warranty_1_6_test | gzip -c > /var/www/test/postgres/backup$(date +"%Y%m%d_%H%M").tar.gz Also: Code: postgres@myhost:~$ ls -lah /var/www/test/postgres/ total 8.0K drwxrwxrwx 2 postgres postgres 4.0K 2007-06-14 12:01 . drwxr-xr-x 3 user user 4.0K 2007-06-14 11:47 .. Running the backup command via CLI works fine.
View Replies!
View Related
How To Dump All Relaying Email?
How to dump all relaying email? I have a domain that used to have a huge members list with thousands of email addresses. Now that I enabled its web site, the server attempts to relay email meant for those harvested addresses. Also, spam relayers picked up that the DNS is live and try to use the domain to deliver spam What can I do with the MX records in order to dump all email without the server handling it? Currently all email is set to :blackhole:
View Replies!
View Related
Should I Dump My Host For 1&1
I love my current host. It's fast, has excellent support, uptime is great, and I get a lot of features. I'm paying $10 a month for it, though. I'm thinking about moving to 1&1. Is this a bad idea? I had 1&1 about a year or two ago, but canceled it because I didn't end up building the website I ordered it for. Didn't have any issues, but the cancellation process was a pain. Nothing major, though. The thing that 1&1 has going for is it is the price. $4 a month is a darn good deal. That's 2.5x cheaper than my current host. I could save a lot of money. I know, you get what you pay for... So am I being stupid? I don't use a lot of bandwidth (I used 1.5GB last month, and average less than 1GB), and my website hosts my software that I sell, so a lot of downtime is obviously bad. The only thing I see that's bad about the $4/month plan is no ssh access, which is really only convenience for me (I don't require it).
View Replies!
View Related
Core Dump Files
Files such as core.12762 keep appearing in the root web directory. Amount of core files appearing seems to be proportional to traffic. On average one core file per few million php requests. Will appreciate advice on how to troubleshoot this issue, or how to disable the core dumping. As it is one error per few million requests it does not seem significant enough to spend several hours troubleshooting.
View Replies!
View Related
Copying Whole Dump Over Ssh
I am having a hosting account with old host which is limited to 10 GB, and there i am having a mysql Database which is of 2 GB, i want to move it to new host via SSH ... as that Database can not be downloaded via phpmyadmin due to its size. So i want to "tar" the mysql directory and ssh/scp to new host!... I am applying this command... tar -cvf r.tar /var/lib/mysql/in_supp | ssh user@newhost.com But i am getting errors, Please give me a command which can move my entire Database dump to new server, without creating any copy at old server "as i do not have any space there"
View Replies!
View Related
IDENT Authentication Failed For Postgres. Pg_hba.conf
I just reloaded the OS on our production server and I'm having issues configuring postgres. the user postgres exists in the system (i.e. 'su postgres' switches me to that user) i attempted to connect to my database 'service_2_3' via CLI: Code: $ su postgres $ psql service_2_3 and i recieved the following error: Code: psql: FATAL: IDENT authentication failed for user "postgres@service_2_3" the database is installed on the machine on which i was attempting to connect to it with. therefore, i edited my pg_hba.conf so that it looks like this: Code: # TYPE DATABASE USER CIDR-ADDRESS METHOD # "local" is for Unix domain socket connections only local all all ident sameuser # IPv4 local connections: host all all 127.0.0.1/32 ident sameuser # IPv6 local connections: host all all ::1/128 ident sameuser host all all 0.0.0.0 0.0.0.0 password and reloaded with (as user postgres): Code: bash-3.00$ pg_ctl reload -D /var/lib/pgsql/data -l /var/lib/pgsql/data/temp.log but i still get the same error. am i editing the wrong file, perhaps? how would i know which is the correct pg_hba.conf file? locate pg_hba.conf seems to give me a few results.
View Replies!
View Related
Mysql Database Dump (150mb) Utf8
recently I had problems with backing up my ~150mb database through PHP. And I know some people are backing their databases to a dump file through terminal. My database contains UTF-8 and other characters. I have tried simply dumping with mysqldump but I doesn't seem to work, when restoring all the characters are messed up. Is there any command to tell that the database is UTF-8?
View Replies!
View Related
Restoring Mailboxes
I am in the process of migrating client's website and mailboxes. My server is using Plesk 8.1 with horde as the default webmail applacation and had to install Squirrelmail beacause he was using this program integrated in his website. I have been able to install it, configure it, it works both on Http and Https and i'm able to receive and send emails. After this i'm trying to restore all the mailboxes into the new server (10 GB worth of mail) but i can't seem to find where to place that folder. I have tried google and looked everywhere suggested but can't find the folder where mails are stored I have been able to find the folder where the addressbook and config file for every account is located (/var/qmail/mailnames/DOMAIN/ALIAS) but there are no emails there despite the fact that they appear in the Inbox in Squirrelmail. The server is running Debian 3.1 with Plesk 8.1 and Squirrelmail 1.4.4
View Replies!
View Related
Restoring Files
I had my server with FDCservers and its back after 2 days of horrible downtime which according to them was due to hardware failure. Server specs: Intel Core 2 DUO E6600 @ 2.40 GHz 4096 MB RAM 400 GB HDD cPanel The old drive has Fedora 5 running with cPanel but on new drive, its CentOS 4.5 with cPanel. Now, I want to restore the files from old(slave) drive to master(main on which centOS is running) How do I do that? Isnt there any possibility since I changed the Operating System.
View Replies!
View Related
Restoring Database
Here's the situation: Moving from VPS to Dedicated, VPS (cPanel) and Dedicated (Plesk)... I FTP'd all the files, what's left is the database. I was going to restore the db using SSH, but I had to FTP it first, so I tried but half-way it would time out (disconnect from server) Right now I am trying phpMyAdmin, I doubt it will work. Is there a way to transfer from cPanel to Plesk? DB size is 400MB
View Replies!
View Related
Getting Error While Restoring Database.
SQL query: /*!40000 ALTER TABLE `qhvbmailer_attachments` DISABLE KEYS */; MySQL said: Documentation #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 '; UNLOCK TABLES; -- -- Table structure for table `qhvbmailer_campaigns` -- DRO' at line 1
View Replies!
View Related
Restoring Email To A VPS
I have an existing client with about 200 email accounts, I want to migrate all of them off of our server and to a VPS or something. They wil use a webmail to access them. Is that possible? Also, is it possible to give the client access only to create email accounts without giving them access to the whole hosting control panel?
View Replies!
View Related
E2label (Restoring Backup From Old Primary)
I have a smart error of possible hard drive failure on a hard drive of a cPanel server. Before I ask for replacement of new drive, I'm going to get a new hard drive as New Primary and make the Old Primary as Secondary Drive (To Restore) I have the complete manual to restore. However the last time I tried to do that same thing, the system OS crash because it cannot tell which one is primary, and which is secondary (Both is SATA) My partition is /boot 100mb swap 2gb /tmp 500mb / rest of disk no LVM, installed on MBR I remember the last time I read something about e2label to rename my hdd label which cause the OS crash when new+old primary was booted together.
View Replies!
View Related
Error With Mysql While Restoring Account
I was trying to restore an account via SHH and I get this message while the process arrived at restoring databases: Quote: ERROR at line 4236: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 4237: DELIMITER must be followed by a 'delimiter' character or string Done Restoring database roundcube...... /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'roundcube'; database exists' ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 33: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 77: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 120: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 121: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 163: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 164: DELIMITER must be followed by a 'delimiter' character or string Done Restoring database horde...... /usr/bin/mysqladmin: CREATE DATABASE failed; error: 'Can't create database 'horde'; database exists' ERROR 1146 (42S02) at line 23: Table 'horde.turba_objects' doesn't exist ERROR 1146 (42S02) at line 24: Table 'horde.turba_objects' doesn't exist ERROR 1146 (42S02) at line 25: Table 'horde.turba_objects' doesn't exist ERROR at line 31: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 32: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 66: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 67: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 68: Table 'horde.horde_prefs' doesn't exist ERROR 1146 (42S02) at line 69: Table 'horde.horde_prefs' doesn't exist ERROR at line 75: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 76: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 110: Table 'horde.kronolith_events' doesn't exist ERROR 1146 (42S02) at line 111: Table 'horde.kronolith_events' doesn't exist ERROR 1146 (42S02) at line 112: Table 'horde.kronolith_events' doesn't exist ERROR at line 118: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 119: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 153: Table 'horde.kronolith_storage' doesn't exist ERROR 1146 (42S02) at line 154: Table 'horde.kronolith_storage' doesn't exist ERROR 1146 (42S02) at line 155: Table 'horde.kronolith_storage' doesn't exist ERROR at line 161: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 162: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 196: Table 'horde.mnemo_memos' doesn't exist ERROR 1146 (42S02) at line 197: Table 'horde.mnemo_memos' doesn't exist ERROR 1146 (42S02) at line 198: Table 'horde.mnemo_memos' doesn't exist ERROR at line 204: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 205: DELIMITER must be followed by a 'delimiter' character or string ERROR 1146 (42S02) at line 239: Table 'horde.nag_tasks' doesn't exist ERROR 1146 (42S02) at line 240: Table 'horde.nag_tasks' doesn't exist ERROR 1146 (42S02) at line 241: Table 'horde.nag_tasks' doesn't exist ERROR at line 247: DELIMITER must be followed by a 'delimiter' character or string ERROR at line 248: DELIMITER must be followed by a 'delimiter' character or string Done What does this error mean and how to solve this problem? I have updated cpanel and mysql but the problem is still found This problem found while trying to restore any account not this one only..
View Replies!
View Related
Error When Restoring Reseller Privs
i try to restore a backup from another hosting to my server and always get stucked on "restoring reseller privs" i'm using restorepkg username and got this error Code: not a reference at /usr/local/cpanel/Cpanel/CachedDataStore.pm line 27 at whm i can transfer multiple account and select "skip restoring reseller privs" but in this case my old hosting doesnt provide ssh access. i was wondering is there any paramater to skip that? something like Code: /scripts/restorepkg -somethingblahblah accusername
View Replies!
View Related
Restoring Accounts To Addon Domain
Currently, 2 domains hosted on a dedicated server with each account having its own Cpanel. I'm going to move/migrate these 2 domains to a shared hosting server. The shared hosting accont has Cpanel and I've added 2 Add-on domains (the same ones on the dedicated). In total, there are 3 domains under the shared hosting account; The main domain and the 2 other (add-on) domains. My question is it possible to restore these 2 accounts under a single cpanel account and having all the emails intact? So, in essence, I'm having a single cpanel account to manage the 2 domains to be transferred from the dedicated.
View Replies!
View Related
Restoring Incremental CPanel Backups To A New Drive
We have incremental backups running in our server. We want to move the cPanel accounts to a new cPanel server and restore in that server. The Backup Restore option in WHM will recognize only compressed backups (like .tar.gz) when it is placed in the /home directory. So how do I do about restoring a incremental backup through the WHM of the new server?
View Replies!
View Related
Restoring Full Backups - CPanel And PuTTy
I’ve just switched to a deticated server. I have backups of sites I need to move over and restore. cPanel has a “Restore a Full Backup/cpmove” option. Two questions… 1) How do I upload the back up file to the /home directory of my deticated server? 2) If the backup file is under a current client “/home/clienta” how do I restore it? I’ve also tried using puTTy to restore the file. - logged into as “root” - typed “cd /home” - typed “/scripts/restorepkg domainname”
View Replies!
View Related
BackupPC Restoring Files Without GUI Or Command Line
I got our server staff to install BackupPC on our dedicated server and run daily backups. All is well (from what I can tell) but i've come to a point where I want to actually use an archived file. So I jump into my ftp client, navigate to the backup folder, and download the file. The problem is, the file reads as jibberish. I'm assuming that BackupPC has compressed it. So the question is two-fold: 1. How do I decompress it on windows (command line stuff is well beyond me) 2. Is there any browser/windows apps that I can use to manage the backups?
View Replies!
View Related
Restoring Mysql Db From .frm, .MYD, .MYI Files
I did the absolutely most stupid thing yesterday, I emptied the wrong mysql table via phpmyadmin. Fortunately my host managed to grab a the table in question from a few days ago. So I have: auctions.frm, auctions.MYD, and auctions.MYI My assumption, is that I can just overwrite the current files of the same name in the mysql folder, and everyone will be happy. Is there some more to this process?
View Replies!
View Related
SQL
i have problem to get a script to work... i want to query coloum "DateTime" in an Access DB, it will return correct info if i wrote as sql query: Select DateTime from DB where Datetime = '2/7/2007'; i want to implement this to VB, in VB i've defined a Startdate and Enddate... "Select DateTime from DB where Datetime >= " & " 'StartDate' " it will return StartDate as whole word "StartDate", not the actually startdate. if i wrote: "Select DateTime from DB where Datetime >= " & Startdate it will return correct "Startdate" as 2/7/2007, but the query is not successful.. Access required format is '2/7/2007'...
View Replies!
View Related
Sql Injection
I had a non client send me an email about being hacked. apparently the hacker is using a program/command line and is entering this into the db: user=' &pass1=111-222-1933email@adress.tst&pass2=test&submit= create%20Account any way he can patch up his navicat database to stop this?
View Replies!
View Related
MS SQL 8 Upgrade To 10
I try to relocate a database from my MS-sql8 server to a MS-sql 10. I can't get it to work as it should on the new host. I have used the deattach / atttach method and after that i can login to the db in the new server and make selects. However stored procedures or views does not work. If i try to access them from a vbscript it get an error telling me that the stored procedure does not exicst. If I use the admin tool I can verify that it is there.. Can someone explain what to do? the db is owned by the user and should have all user rights thats needed, but apparently i guess that something is missing.
View Replies!
View Related
MS SQL Performance
We run a very busy web application written in .net . The backend is SQL 2005. The server running SQL for this web app is slammed constantly. CPU is red lined, and the disks are queuing up because they cant keep up with the demand. What I am wondering is what do the big websites do to gain performance? What direction should we start moving in to get ahead of the curve. We are using an HP DL 580 with 4 x quad core xeons and the fastest SAS drives we could get.
View Replies!
View Related
SQL Upload
I'm trying to upload a 15mb SQL file via PHPMYADMIN, and each time I try it takes ages loading and then I get the following error: Fatal error: Maximum execution time of 300 seconds exceeded in /usr/local/cpanel/base/3rdparty/phpMyAdmin/libraries/import/sql.php on line 118
View Replies!
View Related
Copy Sql
How do I copy an entire mysql sql database file via ssh? Inside /var/lib/mysql the sql are per table, not one single sql. The db is over 300mb in size too. Using mysql 5/centos 4.6
View Replies!
View Related
SQL On SSD
Has anyone here ever tried running MySQL on a solid-state drive? I'm writing an Intranet application that seems like the perfect use case for one--this thing won't need a lot of throughput, but it's going to be doing involved searches all over the database, making seek times relatively important. Obviously, gobs of RAM would be the best solution. But lacking that, I wonder if anyone has actually tried solid-state for an SQL server? Am I expecting too much? (My installation won't use more than a couple gigs of space, and isn't moving major traffic... I'm aware that SSD would be a terrible solution if I wanted to, say, host WHT.)
View Replies!
View Related
MS SQL Backup
I don't know if this subject was discussed previously. What I want is to know how can I have daily backups to my MS SQL Server 2005 databases? From the management I see that I can make manual backups, but not scheduled one. Do I need a 3rd party software?
View Replies!
View Related
SQL Upload
Im having problems uploading a 250mb sql DB thru Phpmyadmin in localhost. Can someone please help me out with this one? Is there a better way to do this. It keeps telling that the file is too large to upload thru phpmyadmin.. I have edit the php.ini file but no luck it still says the same thing. What I basicly just want to do is to look at my old database tables that I had from my old site. I need all my members information so that I can start migrating info. Is there a software that just allows me to look at my sql DB ? I have a local copy in my hard drive.
View Replies!
View Related
My SQL Password
about MY-SQL Password Security! my Server is : CentOS and my control panel is : Cpanel my Freand have a mySQL password, but he donot know ROOT Password ( i change root password ) my Freand is a bad Boy ) can he attack Mysql or Mysql user by mysql password? if he can attack server by Mysql password please help me about change Mysql password by CPANEL
View Replies!
View Related
SQL Too Large
I'm having a lengthy issue where my databases are to large to import in phpmyadmin using plesk. Unfortunately I dont have direct access to phpmyadmin and can only access it by DB user through plesk. I have tried to edit php.ini in the following locations: upload_max_filesize = changed this to 64M post_max_size = changed this to 32M maximum_execution_time = changed this to 300 maximum_input_time = changed this to 300 Why am I still not able to import my DB's which are about 8MB each?
View Replies!
View Related
Plesk 8.2 And MS SQL
I have been doing a bit of testing of MS SQL on Plesk, and I have a local database (MS SQL Standard 2005) and I can make a create script which references MDF files. However I'm not sure how I would import this into MS SQL? Whats the best way to export data from MS SQL and then import to a new server? Version of MS SQL: Express 2005 Version of Plesk: 8.2
View Replies!
View Related
|
TRACKER
