MySQL Forums
Forum List  »  Newbie

Tables getting dropped when new table imported
Posted by: Tog Porter
Date: July 10, 2018 09:29AM

Hello.

I am new to MySQL. I have a website with 1&1.co.uk and it includes a MYSQL database accessed via PHPMyadmin in plesk.

The database has 10 tables in it. When I import a new table the system adds it but also drops the other 9 tables.

I then have to re-import the other tables one by one. That works, but it is a lengthy workaround. I think the problem is that the new table is larger than the max allowed and this is somehow causing the other tables to be dropped.

Does anyone know how I can increase the maximum size of a database that can be imported, or could there be another reason that the other tables are getting dropped when I import the new one?

I am importing each table using a zip file.

Many thanks in advance.

Tog

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

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.