Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > linux.debian.user > #182787

Re: OT: SQL database - some questions

Show all headers | View raw

Hi Greg, 
huuuuuu, that looks quite difficult for me. 
> Start by actually reading the compressed backup, using zless.  See whether
> it looks like an SQL dump.  If it does, then you can proceed to the next
> steps.
> 
Ho dso I do this? I unzipped my *.sql.gz and have now *.sql file. How can I 
see, if it is a sql-dump? What is this?


> Install mariadb/mysql (whatever the server package is called, for your
> release of Debian).  Do whatever it is you need to do in the database
> admin account so that you can restore your database dump as your regular
> user.
> 

I have installed mysql, but I do not want to run it as root. I am not sure, to 
kill some databases on my system, I need for other things. 

> As your regular user, feed the compressed database dump to the "mysql"
> (or its mariadb equivalent) command:
> 
> zcat yourfile.gz | mysql
> 
How can I create a database as a npormal user? mysqladmin inhibits this. I did 
mysqladmin db1 , then mysql db1 < mydatabase.sql , which only worked as root.

> You may have to supply a password, or some command line options to mysql,
> or something like that.  Whatever you would normally do to restore a
> mysql database dump.

Too heavy for me, sorry.
> 
> If you get stuck, try googling "restore mysql database dump" or similar.
> Yours is presumably compressed, due to the *.gz suffix on the file, so
> you'll need to zcat it, instead of just feeding it directly to mysql.
> That's pretty much it.

Same, too heavy.

Folks, I think, this is not an easy stuff! I am not experienced enough and I 
give up for now. 

Maybe I will take the other solution by using vim, and extract all my blogs 
from the sql-file manually, then put it into an html editor like bluegriffon, 
and then save all the blogs in a html file. Doing so, they can be trancoded 
into pdf or implemented into ODT. However, this is a lot of manual work, but 
not "brain killing" like this. 

I hoped, there would be an easy way, opening a GUI, choose my text with drag-
and-drop and off we go. 

Sorry, there is none, I see now. Let this issue close, thanks, great thanks, 
for all the help, really, but it is going much too far now.

Best wishes and thanks again

Hans

Back to linux.debian.user | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

OT: SQL database - some questions Hans <hans.ullrich@loop.de> - 2017-06-28 10:10 +0200
  Re: OT: SQL database - some questions Mirco Piccin <pictux@gmail.com> - 2017-06-28 10:50 +0200
    Re: OT: SQL database - some questions Hans <hans.ullrich@loop.de> - 2017-06-28 11:00 +0200
      Re: OT: SQL database - some questions Darac Marjal <mailinglist@darac.org.uk> - 2017-06-28 11:20 +0200
        Re: OT: SQL database - some questions Hans <hans.ullrich@loop.de> - 2017-06-28 14:30 +0200
          Re: OT: SQL database - some questions Greg Wooledge <wooledg@eeg.ccf.org> - 2017-06-28 15:00 +0200
            Re: OT: SQL database - some questions Hans <hans.ullrich@loop.de> - 2017-06-28 15:20 +0200
              Re: OT: SQL database - some questions Joe <joe@jretrading.com> - 2017-06-28 17:40 +0200
      Re: OT: SQL database - some questions Mirco Piccin <pictux@gmail.com> - 2017-06-28 11:20 +0200
      Re: OT: SQL database - some questions Brad Rogers <brad@fineby.me.uk> - 2017-06-28 11:30 +0200
  Re: OT: SQL database - some questions Celejar <celejar@gmail.com> - 2017-06-29 01:10 +0200
    Re: OT: SQL database - some questions Richard Owlett <rowlett@cloud85.net> - 2017-06-29 12:20 +0200
  Re: OT: SQL database - some questions Joel Rees <joel.rees@gmail.com> - 2017-06-30 00:50 +0200

csiph-web