Re: OT: SQL database - some questions

2017-06-29 Thread Joel Rees
On Wed, Jun 28, 2017 at 5:00 PM, Hans wrote: > Dear list, > > this is a little offtopic, but maybe you can make things a little bit clearer > for me. > > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup of a

Re: OT: SQL database - some questions

2017-06-29 Thread Richard Owlett
On 06/28/2017 01:29 PM, Celejar wrote: On Wed, 28 Jun 2017 10:00:00 +0200 Hans wrote: Dear list, this is a little offtopic, but maybe you can make things a little bit clearer for me. I had had a webserver hosted by a provider, which is switched off since a year. From

Re: OT: SQL database - some questions

2017-06-28 Thread Celejar
On Wed, 28 Jun 2017 10:00:00 +0200 Hans wrote: > Dear list, > > this is a little offtopic, but maybe you can make things a little bit clearer > for me. > > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup

Re: OT: SQL database - some questions

2017-06-28 Thread Joe
On Wed, 28 Jun 2017 15:12:26 +0200 Hans wrote: > Hi Greg, > huu, 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. >

Re: OT: SQL database - some questions

2017-06-28 Thread Hans
Hi Greg, huu, 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

Re: OT: SQL database - some questions

2017-06-28 Thread Greg Wooledge
On Wed, Jun 28, 2017 at 02:25:55PM +0200, Hans wrote: > sqlbrowser looked best promising, but my sql databases can't be opened with > it. I want to export the *.sql file into a new database, but I get stuck with > an error. Telling ???e "unknown statement: 1#, unrecogized token: 1"#"", so > it

Re: OT: SQL database - some questions

2017-06-28 Thread Hans
sqlbrowser looked best promising, but my sql databases can't be opened with it. I want to export the *.sql file into a new database, but I get stuck with an error. Telling ḿe "unknown statement: 1#, unrecogized token: 1"#"", so it looks like a format error. Well, I do not know, what is

Re: OT: SQL database - some questions

2017-06-28 Thread Brad Rogers
On Wed, 28 Jun 2017 10:53:02 +0200 Hans wrote: Hello Hans, >Maybe I should precise my question: How can I restore my data from this >sql database on my desktop? Is there a tool to extract my blogs? 'sqlitebrowser' _may_ be of some assistance. Disclaimer; I've only used

Re: OT: SQL database - some questions

2017-06-28 Thread Darac Marjal
On Wed, Jun 28, 2017 at 10:53:02AM +0200, Hans wrote: Am Mittwoch, 28. Juni 2017, 10:41:05 CEST schrieb Mirco Piccin: Hi Hans, Hi Mirco Here more info: https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/reloading-sql-format-d umps.html sorry, but that was not quite the thing, I was

Re: OT: SQL database - some questions

2017-06-28 Thread Mirco Piccin
Hi Hans, > Maybe I should precise my question: How can I restore my data from this sql > database on my desktop? Is there a tool to extract my blogs? > > I do not want to build a webserver with php and wordpress and so on, just > extract my blogs. Phpmyadmin needs a webserver to run. This is

Re: OT: SQL database - some questions

2017-06-28 Thread Hans
Am Mittwoch, 28. Juni 2017, 10:41:05 CEST schrieb Mirco Piccin: > Hi Hans, > Hi Mirco > Here more info: > https://dev.mysql.com/doc/mysql-backup-excerpt/5.7/en/reloading-sql-format-d > umps.html > sorry, but that was not quite the thing, I was looking for. > After restore, you can browse the

Re: OT: SQL database - some questions

2017-06-28 Thread Mirco Piccin
Hi Hans, > I had had a webserver hosted by a provider, which is switched off since a > year. From this server I got a backup of a sql database. The system that ran > that time, was wordpress, and the database is called something like > "bla_bla_wp2016018_911.sql.gz" i suppose the backup has all

OT: SQL database - some questions

2017-06-28 Thread Hans
Dear list, this is a little offtopic, but maybe you can make things a little bit clearer for me. I had had a webserver hosted by a provider, which is switched off since a year. From this server I got a backup of a sql database. The system that ran that time, was wordpress, and the database is