Browsing articles tagged with "dump - Admins Goodies"
Nov 1, 2012
tom

MySQL Dump Viewer

I’m a linux user, however, I’m provided with a Windows laptop in the office. I could fire up a small web server with PHPmyadmin or even upload to a remote system and import into a database, however, for what I’m doing, I’d like to know if there is anything easier? What I have is a MySQL Dump file of a database. I need to know if there is anything out there that can read in […]

Continue Reading »
May 15, 2012
tom

Create dump of database schema remotely

I have a connection to remote Mysql database. (i’m using MySQL Workbench). I’d like to copy whole structure of the database, (without data) to create identical structure on my local machine. Is it possible if I have only username and password to access that database? Asked by pnkpnd mysqldump -h <host/ip> -u <user> -p<password> <database> > export.sql Note that there is no space between -p and the first character of the password. Answered by leepfrog […]

Continue Reading »
Mar 19, 2012
tom

Dump all databases to file

Possible Duplicate: Out of resources for mysqldump I’m trying to export all databases from my wamp installation (so I can do a reinstall), but I get this error when trying to generate a dump file: C:\wamp\bin\mysql\mysql5.1.36\bin>mysqldump -u root –all-databases > dbs.sql mysqldump: Got error: 23: Out of resources when opening file ‘.\site\posts_rg_lea d_detail.MYD’ (Errcode: 24) when using LOCK TABLES the export stops after ~70 MB… Asked by Alex Error 24 is : “Too many open […]

Continue Reading »
Jan 31, 2012
tom

how to get text with sed?

i want to grab the the text between tok98 and 5678 and dump that out to a file. if the tok98 and the 5678 was on the same line i can use this sed -n ‘s/.*(tok98)(.*)(5678).*/2/p’ testfile.txt > text.dmp but when the tokens are vertically spaced its not working, how can i rewrite this sed to work here $ cat testfile.txt do with > 9 tok98 fdf df s df sd f sd v dvsdv […]

Continue Reading »
Jan 7, 2012
tom

Good practices for backing up MySQL on a large scale

Sorry for the silly question, I am newbie to DB and particular to Mysql. My question is there are any good practices to backup Mysql on large scale. For example, there are few thing I’ve already found Use mysqlbackup (physical backup) instead of mysqldump. increase key_buffer_size to 20% of RAM (not just for backup extremely helpful option). take a look at tools of maatkit there are few for backup. If you aware of any good […]

Continue Reading »
Nov 26, 2011
tom

How to install Oracle’s exp / imp binaries

I was browsing the net to find a solution, but I had no luck. How can I install Oracle’s imp / exp binaries to my CentOS box without installing an Oracle Server? I’m accessing an existing Oracle database on another machine, so I only need a client here. I already installed sqlplus and its dependencies (oracle-instantclient11.2-basic-11.2.0.3.0-1.x86_64.rpm, and oracle-instantclient11.2-odbc-11.2.0.3.0-1.x86_64.rpm), but that didn’t provide those tools. Do I really need to fully install Oracle? My aim is […]

Continue Reading »
Oct 9, 2011
tom

Splitting up SQL server dump

Is there a way how to split up dump of whole database server (with such tables as ‘mysql’ or ‘information_schema’) to single databases? Looking for better way than insert this whole dump and export needed databases… Need to recover only part of this dump (only single databases) try this: awk ‘/USE `/{i++}{print > “file.”i”.sql”}’ yourFullMysqlDump.sql it’ll create file.X.sql for each of the databases Check more discussion of this question. Bookmark on Delicious Digg this post […]

Continue Reading »
Sep 11, 2011
tom

Linux dump file – can it be read on Windows system?

Is there a way to mount/read linux file created with /sbin/dump under Windows system? You can compile dump on windows using mingw ( heck, it might even already be done for you in msys ), and use restore to read it just like you would on linux. Check more discussion of this question. Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with Stumblers Tweet about it Print for later Bookmark […]

Continue Reading »
Aug 20, 2011
tom

Dump output very small

So I made a dump of one of my drives today which totalled 171GB and did a level 0 dump which had a output size of 58GB. I dont know why it was so small, but I wanted to ask if dump searches for a past level 0 even when you instruct it to do a level 0. There is another level 0 on the drive from September. Linux 2.6 Kernel EXt3 Reading through the […]

Continue Reading »
Aug 20, 2011
tom

Dump/Restore and Deleted files

Our Management told us we needed to wipe down some our drives, who knows why. We were told to delete certain documents and then backup the remaining files to a external medium, wipe then restore the remaining files. I usually just use Dump/Restore to do backups as it works great and is very simple. I simply used rm() to delete the files, created a zeroed file to fill the drive, deleted that file, then did […]

Continue Reading »
Pages:12»