Which means MySQL router API cannot be used by developers for calling db while developing code?

Only if you export it as flat file, like csv….

Thank u so much

hi guys, i want to learn to create a database where i can do everything in these topics. Most of the time when learning the topic, the example given was different for each topic. i find it hard to learn to create a complete fungsional database like that. can you guys give me database example (or link for such problem) where i can perform all those topics ?

What format of example do you need?

anything.

Is there any option in percona xtrabackup to estimate the backup size
Only estimate??

I suppose you can only define a chunk size

If we talk about the utility options

Actually I have a database of 1.6tb and I need to restore it to a remote server
And for that I need space estimates.
Considering the size of the backup file would be less than the actual db size then I would request for 1.6tb + backup size amount of space on the remote server

Hello, I did an update on ubuntu server and mysql was updated from v8.0.22 to v8.0.23.
Mysql cannot start with files missing(mysql.pid is not created.
Any help on how to recreate it.

you need create directory /var/run/mysqld and chown mysql.mysql /var/run/mysqld

I did that and it created the sock files but it never created the pid file.

show me the log error

I have this on the log files

SOLVED! Not sure what I did but its working now

Do we have RESTful API interface in MySQL? Any suggestions?

How do you imagine RESTful DDL operations?

Hi there,

I have a table contains items, some of these items advertised, so i make another table (ads) which contains ids of advertised items, what I would like to get is to pagnation items, first show advertised items, when all advertised items get other items,

is there any SQL stament to do that?

No. It is a DBMS

Pagination is a task of the client of the DB.

And is an anti pattern for DB.
Use search criteria and filter data, create smart queries.

MySQL :: MySQL Router 8.0 :: 6.1 A Simple MySQL Router REST API Guide
https://dev.mysql.com/doc/mysql-router/8.0/en/mysql-router-rest-api-setup.html

Yes. I want my developers to use the RestAPI for making calls to databases through a web interface

Yep. Wanted to understand if MySql has inbuilt RestAPI ntetface or 3rd party RestAPI interface

Can someone please let me know if this page has the same ask that I have?

Mysql router is different than mysql db

Thanks for answering. Which means MySQL router API cannot be used by developers for calling db while developing code? No built in RestAPI available for db in MySQL. Is that right..

Yes

I meant how can I use (limit, offset) to get first advertised items, after that get other items.
for example, if I have 20 items in my items tables, 11 of them are advertised, when client first request, the server retrieve 10 items who are advertised.
after that retrieve the last advertised items and then the other 9 items.

I need that by writing an sql query with (limit, offset)

MySQL doesn’t have any http interfaces, it uses other protocols.

It is an antipattern for a relational DBMS, don’t do things like this

So how can I structuring my DB to do what I explained

You should not do this at all.
Learn SQL, write queries, that is all you need