Topic: help share database from disatnce

Can somebody help me how can work my database from distance. What I wanna is to share my database with  more than two persons from distance and not from the same space. How can I do that (if it's possible step by step).

Re: help share database from disatnce

There is two options.


1. Use own PC as server, but your Internet connection must have public IP address, do you have?


2. You can buy virtual hosting. (about 4 euro per month).


What is your case?

Dmitry.

3 (edited by v_pozidis 2018-08-23 07:31:29)

Re: help share database from disatnce

I have a dynamic IP.


1.  Can I use Xampp for having server home ? and if yes how  can i do that ?


2. In case I bye spase how can I do it .

for both  how can I continue the procedure to continue using mvdb ?
Is there a video or a tutorial (step-by-step) ?

Re: help share database from disatnce

Can somone explain me how to upload my db file so we can work by distance, please!!!!

Re: help share database from disatnce

If you have dynamic IP, you can use Free Dynamic DNS, like this
https://www.noip.com/support/knowledgeb … no-ip-com/


How to install MySQL
http://myvisualdatabase.com/forum/viewtopic.php?id=1734


The easiest way to do that is to buy virtual hosting.


I can help you only with specific question.

Dmitry.

Re: help share database from disatnce

Hi, ok I have install MySQL, what I do not understand is how do I import the sqlite.db file to a web server. Do I upload the file (sqlite.db) as it is,  or do I import the data's from the file (sqlite.db) using MyphpAdmin. ?

Re: help share database from disatnce

Send me the sqlite.db and let me convert it to SQL that you can import onto mysql through phpMyAdmin

@thezimguy

8 (edited by thezimguy 2018-08-29 06:47:53)

Re: help share database from disatnce

Navicat

@thezimguy

Re: help share database from disatnce

thezimguy wrote:

Navicat

I am at work and do not have my software.
Because I like to learn how do I convert it ? What software do I use ? And could you please explain me step - by step the procedure using phmMyAdmin and all the rest to connect using the MVDB ?
Thank you in advance.

Re: help share database from disatnce

I use Navicat Premium
After loading your sqlite.db into navicat
follow the image below to export the database as .sql so that you can import into sqlite
https://s6.postimg.cc/62sfzpcg1/dump_SQL.png

@thezimguy

Re: help share database from disatnce

Thank's for your help. After that us I understand I get a new file like sqlite.slq whih I import to phpMyAdmin.
Can you suggest me a free web site  to test it?

12 (edited by thezimguy 2018-08-29 07:13:09)

Re: help share database from disatnce

You can set up a local server on your PC using xampp server.
follow link https://www.wikihow.com/Install-XAMPP-for-Windows

You can also sign up for free at http://000wehost.com

But I suggest you start with xampp to build the project which is an offline server. So that when you are ready you can export it online

@thezimguy

Re: help share database from disatnce

I have an account  in 000Webhost . To be honest I tried it but it fails using MVDB. I will try it but where do I found the name for the server and the port and all the stuff to use it to be connected with MVDB ?

Re: help share database from disatnce

v_pozidis wrote:

I have an account  in 000Webhost . To be honest I tried it but it fails using MVDB. I will try it but where do I found the name for the server and the port and all the stuff to use it to be connected with MVDB ?

Remote MySQL connections are available with premium accounts only, free accounts do not support that option
Meaning with the free account you can't connect it on 000Webhost.

@thezimguy

Re: help share database from disatnce

thezimguy wrote:
v_pozidis wrote:

I have an account  in 000Webhost . To be honest I tried it but it fails using MVDB. I will try it but where do I found the name for the server and the port and all the stuff to use it to be connected with MVDB ?

Remote MySQL connections are available with premium accounts only, free accounts do not support that option
Meaning with the free account you can't connect it on 000Webhost.

Oh no!  DO you know a free hoster?
Thank's again.

Re: help share database from disatnce

Try https://www.freemysqlhosting.net
MySQL Database
5MB MySQL Hosting Space
phpMyAdmin
Secure, Reliable, Fast hosting
Upgrade options available

I have not yet tried it. I will try it and communicate to you if it works

@thezimguy

Re: help share database from disatnce

Thank's I will wait

Re: help share database from disatnce

The link I sent above is perfect. It works
In MVD
https://s6.postimg.cc/sdkwd6twh/connect_My_SQL_online.png


@freemysqlhosting
https://s6.postimg.cc/bd204jr5t/freemysqlhosting_Account.png

@thezimguy

Re: help share database from disatnce

Try it and give me feed back
Regards

@thezimguy

Re: help share database from disatnce

NOTE: It's just for testing purposes
The maximum database size is 5mb.
Contact Dmitry for premium account.
Regards

@thezimguy

21 (edited by v_pozidis 2018-08-29 11:43:07)

Re: help share database from disatnce

I have downloaded the beta version of MVDB which is portable and created a small program. So I sen it to you in case you could help me to publish it in the https://www.freemysqlhosting.net and see if it works.
I tried it but something in the import seems to fail. Please check it out.
Feel free to change anything of the program

https://drive.google.com/open?id=1ozoAg … 0rfXK98KWB

Thank you

Re: help share database from disatnce

Hello v_pozidis,
I realized the following in your project

You were still connected to the sqlite.db database. But you have to change it to MySQL which I have done in your project.
Just follow this screenshots to complete the process.

Also I hope you have the details when you registered with https://www.freemysqlhosting.net
Thus,

Server: sql9.freemysqlhosting.net
Username: sql9295
Password: fghfgSTCS
Port number: 3306

https://s6.postimg.cc/9cbgk3sk1/MVD_My_SQL.png

https://s6.postimg.cc/dy7ksglsx/MVD_My_SQL2.png

https://s6.postimg.cc/l2pe0x0lt/MVD_My_SQL3.png

If you are still having problems, then send me the details from https://www.freemysqlhosting.net and let me put them in the project
thezimguy@gmail.com
Regards.

@thezimguy

Re: help share database from disatnce

I have done it but when I import it in the phpMyAdmin something hapend and cannot understand.

24 (edited by thezimguy 2018-08-29 12:37:28)

Re: help share database from disatnce

v_pozidis wrote:

I have done it but when I import it in the phpMyAdmin something hapend and cannot understand.

What did you import into phpMyAdmin?

Can you send a screenshot?

@thezimguy

Re: help share database from disatnce

Can not get a screenshot at the moment I do not have acces from here to do that. Can you please download fro here https://drive.google.com/file/d/1ozoAgp … 8KWB/view] program and convert the sqlite.db file  as a sql file and import it in the phpMyAdmin ? there you can find the error I get.
thank's again for your help