MySQL Forums
Forum List  »  Newbie

Database export - import
Posted by: Debtanu Biswas
Date: July 09, 2024 10:07PM

I am trying to export database from one webhost to another. I am not getting the full table and views structure. The import happens but it seems the schema is incorrect. I cannot see the grouped Tables & Views. The steps that I have followed are as follows:-

Export
1. Select the source database
2. Click Export
3. Save the .SQL file

Screnshots (Export) - https://prnt.sc/mWrEZ60N_8Ue

Import
1. Created the target blank database
2. Click Import
3. Choose the .SQL file

There seems to be an error but the import happens nonetheless. The imported DB is without the grouped Tables & Views.

Screenshots (Import) - https://prnt.sc/hYM9RpzQxau1

What am I doing wrong? Thank you for any help.

- Deb

Options: ReplyQuote


Subject
Written By
Posted
Database export - import
July 09, 2024 10:07PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.