Topic on Project:Support desk

Restoring mediawiki downloaded from hosted server (company name: namecheap)

12
Flylikeaseagull (talkcontribs)

Hello. I had all of my files on a hosted server downloaded to a large 4 gb zip file.

In localsettings.php it says:

##Database settings
$wgDBtype = "mysql";
$wgDBserver = "localhost";
$wgDBname = "travb_mw229";
$wgDBuser = "travb_mw229";

Where would this file be?


The information on a new account (which would be the same as the previous downloaded account) is this:

Server: Localhost via UNIX socket
Server type: MariaDB
Server version: 10.1.31-MariaDB-cll-lve - MariaDB Server
Protocol version: 10
User: ...@localhost
Server charset: UTF-8 Unicode (utf8)


Web server

cpsrvd 11.70.0.48
Database client version: libmysql - 5.1.73
PHP extension: mysqli curl mbstring
PHP version: 5.6.30
Malyacko (talkcontribs)

In whatever folder you stored your database file. :)

Flylikeaseagull (talkcontribs)

hello @Malyacko where is the default database file on a mediawiki program? I just created a mediawiki using default program, Softaculous on namecheap cpanel. It was created with MediaWiki 1.23.3

Malyacko (talkcontribs)

That depends on the database backend used (MySQL/MariaDB, Postgres, SQLite, MSSQL, to name a few) and how that database is configured. That's lower in the stack than MediaWiki...

Flylikeaseagull (talkcontribs)

thank you for your time sir!

I am really a newbie at this kind of stuff.

What is the database file usually called?

mysql.php?

Ok, I just dragged and dropped all of my files using winscp to my desktop then zipped them. @Malyacko

Softaculous says:

  • Database-driven (MySQL and PostgreSQL are both supported)

In localsettings.php it says:

## Database settings
$wgDBtype = "mysql";
$wgDBserver = "localhost";
$wgDBname = "travb_mw229";
$wgDBuser = "travb_mw229";

Not sure what you mean by lower in the stack - going to assume not important for now :)

Would the database be located in the folder for my mediawiki, which is automatically created when I used Softaculous to automatically create MediaWiki 1.23.3?

THANK YOU FOR YOUR HELP!

Malyacko (talkcontribs)

Alright, that means that you use a MySQL/MariaDB database, and the database has the name "travb_mw229". I do not know what "Softaculous" or "namecheap" is and which operating system they are running and where they save databases by default.

"Would the database be located in the folder for my mediawiki": Usually not, no.

Flylikeaseagull (talkcontribs)

@Malyacko

Hello sir! I rewrote the original question, with a lot more details.

Any suggestions where these databases would be?

Malyacko (talkcontribs)
Flylikeaseagull (talkcontribs)
2001:16B8:10E0:B500:AC31:65A3:AD3F:9360 (talkcontribs)

Hi Flylikeaseagull!

Actually, you are not really having a MediaWiki question. :-)

You already know that you are looking for a MySQL databse and that this database has the name travb_mw229.

What you now need to know is the folder, in which MySQL databases are stored in your backup. Basically this is a question on where MySQL was configured to store databases in this system.

Wargo (talkcontribs)
Ciencia Al Poder (talkcontribs)
Reply to "Restoring mediawiki downloaded from hosted server (company name: namecheap)"