Topic: phpmyadmin import database

[jameswilson]

Was using the phpmyadmin contrib to export import databses, create users etc. All went brilliantly until i had a sql file > 100mb. I tried uploading to the server hoping it would be seen by phpmyadmin to import but it just said no files available. Where should i be putting it (i used the export deirectory)

Thanks
James

[ReetP]

If you look in the Export section you can see it exports to /var/lib/phpMyAdmin/save/

If you check that directory you will see

Code: [Select]

ll /var/lib/phpMyAdmin/

total 0
drwxr-x--- 2 apache apache 30 Feb 19 22:42 cache
drwxr-x--- 2 apache apache  6 Oct  8  2025 config
drwxr-x--- 2 apache apache  6 Oct  8  2025 save
drwxr-x--- 3 apache apache 18 Oct  8  2025 temp
drwxr-x--- 2 apache apache 28 Oct  8  2025 upload

At a guess I'd look at trying the upload directory - note the file will need to be 0644 apache:apache for it to be seen.
So upload to the upload dir, change the perms/owner and then you shoudl be able to see it.

I just did a Export, copied from save to upload then wen to import and can see the file

"Select File to Imoort"

"Select from the web server upload directory /var/lib/phpMyAdmin/upload/:"

[jameswilson]

Ah great to know thanks, didnt think about the permissions

[Jean-Philippe Pialasse]

starting 100mb  dump I would strongly advise to use cli.

there are so many way it could go wrong with transfer, php app limits (time, memory), httpd service, php-fpm service, communicaiton with mariadb...


the cli is as simple as that

Code: [Select]

mysql DBNAME < file.dump

[ReetP]

^^^^^^^^^^^^^

What he said....