Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database
Ad
IN Php I want to get the 20 record from each table in the database using the php code or mysql store procedure .
Any one help..
Thanks
Ad
Answer
Ad
I've managed to achieve something.
First of all you have to add the file
privilege to the user. So you have to login to mysql as root and run this command:
GRANT FILE ON *.* TO [email protected];
And here's the code that will export each table in a separate file:
$tables = ['specs', 'devices', 'categories'];
foreach($tables as $table)
{
$file = '/home/chromespecs/public/sql/' . $table . '.sql';
DB::statement("select * into outfile '$file' FROM $table");
}
I've just tested it and it works.
Ad
source: stackoverflow.com
Related Questions
Ad
- → I can't do a foreign key, constraint error
- → How to implement DbDongle::convertTimestamps as workaround of invalid timestamps with MySql strict
- → MySQL error "Foreign key constraint is incorrectly formed"
- → Eloquent Multitable query
- → "Laravel 5.1" add user and project with userId
- → Database backup with custom code in laravel 5 and get the data upto 10 rows from per table in database
- → Laravel 5.1 QueryException when trying to delete a project
- → Using Array in '->where()' for Laravel Query Building
- → Chaining "Count of Columns" of a Method to Single Query Builder
- → Laravel Eloquent Joining Strange query
- → convert time using mysql laravel 5
- → How to update a column after an expiration date in MySQL?
- → Foreign key constraint fails on existing key
Ad