Hi, does anyone here know how to upload sql databases to the wordpress. I have couple of databases that I want to store on my wordpress but I wonder what will I do to make this working.
I don't quite understand. What do you want to happen when you upload a SQL database to WordPress? It's a blog platform, not a database server.
17-29% of paid ad clicks are fraudulent. Get protected with Improvely, your online marketing dashboard.
→ Conversion tracking, click fraud detection, A/B testing and more.
Yes, I know it's a blog and not a database server. But I have a content that is stored on .sql file. And as I understand, xml is the format of the files that wordpress stores. My question is, is there something on earth that can upload the articles in .sql file to wordpress?
WordPress does not store data in XML files, it stores data in a .sql file. There is a feature in WordPress which allows you to export as XML; AFAIK this is for users who don't have direct access to their database such as those on WordPress.com.
To use the .sql file, you will need to import it into your database (usually via phpMyAdmin), then connect to it via your wp-config.php file.
How you do it entirely depends on your server setup.
Are you using phpMyAdmin? If so, then there is an 'import' option somewhere there which will allow you to import the contents of the SQL file into your database. If you don't already have a database, then you will need to create one before importing.
Tables are inside the database. So you don't upload a database into it, you upload the tables into the database.
Just create a database (or use an existing one), then use the import tool in phpMyAdmin (you haven't mentioned if you are using this or not) and the appropriate tables will be uploaded into the database (assuming the .sql file contains the whole thing).